IF formula

T

Tufail

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
 
K

kassie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF 4
Data Validation 1
Workday Error #VALUE! 4
Formula 4
somewhat complicated conditional formula 2
Multiple if condition formula required 4
Formula for If "" AND "" are true... 3
Nested IF Help 3

Top