Multiple if condition formula required

[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

 

[Max]

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

 

[Harald Staff]

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

HTH. Best wishes Harald

 

[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.

 

[Max]

I'm out on your new query, sorry.
Maybe others would have ideas for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---