# 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

M

#### Max

One idea
In C1: =B1*HLOOKUP(A1,D1:G2,2,0)
should yield the required result
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik

H

#### Harald Staff

=B1*HLOOKUP(A1,D1:Z2,2,FALSE)

HTH. Best wishes Harald

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.

M

#### Max

I'm out on your new query, sorry.
Maybe others would have ideas for you.
--
Max
Singapore
http://savefile.com/projects/236895