IF formula

[Guest]

Hello,
I have this formula in D1 for multi currency's calculation, following two
currencys I want let calculate with *(multiply) else should be / (divided)

A_1 has Currency name exp:> "JPY, USD, JMD so on...."
B_1 has Amount exp:> "100,000"
C_1 Exchange Rate exp:> "115.00"
D_1 has following formula

=IF(A1="JPY",B1*IF(C1=0,1,C1)+AND(A1="USD",B1*IF(C1=0,1,C1)))

Thanks in advance

 

[Guest]

You have 2 choices, viz an IF statement, or VLOOKUP.
For VLOOKUP, create a table of currencies and their exchange rates. Sort
this alphabetically, and use =VLOOKUP(A1, ExchRates,2,FALSE). You will of
course have to update this table on a regular basis, to ensure that you use
the latest exchange rates.

If you use your existing setup, where you merely use the currency name as a
descriptor, then change your formula to the following

=IF(B1="","",IF(OR(C1="",C1=0),B1,B1*C1))

In this way, a rate of 1 gives the original amount, a rate oof 115 will
multiply by 115, and a rate of 0.5 will halve the amount