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(C 1=0,1,C1)))

Thanks in advance