Multiple if condition formula required


N

Narnimar

How to construct a formula if there are many if condition like this-
IF(A1=D1) then C1=B1*D2
IF(A1=E1) then C1=B1*E2
IF(A1=F1) then C1=B1*F2
IF(A1=G1) then C1=B1*G2
 
Ad

Advertisements

N

Narnimar

Thanks Max. I have similar problem. In this case the cells are formatted to
different currencies E1 is in USD currency formated as $2.5, F1 as € 1.7, G1
as £1.9 and H1 is formated as AED9.0
Now,

C2=USD and D2=3.6800 (General)
C3=EUR and D3=4.7000 (General)
C4=GBP and D4=5.7000 (General)
C5=AED and D5=1.0000 (General)

So,

IF E1=$2.5 then B1=E1*D2
IF F1=€1.7 then B1=F1*D3
IF G1=£1.9 then B1=G1*D4
IF H1=£9.0 then B1=H1*D5
I need the result in B1 with respective currency according to the if
condition.

I need one more result in B2 with general format
IF E1=$2.5 then B2=E1*D2*N1
IF F1=€1.7 then B2=F1*D3*N1
IF G1=£1.9 then B2=G1*D4*N1
IF H1=£9.0 then B2=H1*D5*N1

How can I try that?
Thanks again.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top