if condition on currency formated cells

[Narnimar]

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?

 

[galimi]

Sorry, wrong location:

http://www.nofavor.com/spreadsheets/narnimar.xls

 

[galimi]

I have uploaded an example to http://www.nofavor.com/spreadsheet/narnimar.xls

 

[Narnimar]

Dear Galimi, Your answer is perfect for only one combination of currency.
Sorry but I realize that did not questioned for the way I needed the answer.
In fact in this example I am looking for the local currency value for a item
purhase when I got different price quotations in different currencies.

The data entered in C column are currency codes and the values in D column
are the exchenge prices.
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)
IF a price entered in E1 formated in $ currency then B1=E1*D2 which means
depending on the cell format (example is in $) look at column C and find the
exchange price from the column D and multply into the corresponding exchange
rate 3.680 and return answer 9.20 The answer in B1 should change to if change
the format to of E1 from $ to € (means B1=E1*D2). Thank you and Sorry again.

 

[galimi]

Narnimar,

Please call me via http://www.ExcelHelp.us. It is a free call. I don't
understand what I've missed.