pdvsa
asked on
If statement and Currency Exchange Rates
Hello Experts,
I have an error with the below: "Too many arguments"
Do you see where I have the error?
Any cleanup modifications are welcome.
=IF(k6="USD",Z6,IF(K6="SAR ",VLOOKUP( X6,Exchang eRates_ton y,2)*Z6),I F(k6="EUR" ,VLOOKUP(X 6,Exchange Rates_tony ,2),IF(K6= "GBP",VLOO KUP(X6,Exc hangeRates _tony,2)*Z 6),IF(K6=" JPY",VLOOK UP(x6,Exch angeRates_ tony,2)*Z6 ))
thank you
I have an error with the below: "Too many arguments"
Do you see where I have the error?
Any cleanup modifications are welcome.
=IF(k6="USD",Z6,IF(K6="SAR
thank you
ASKER
Thank you. I have a follow up though. I am not getting the correct exchange rate. Do you see anything that might cause? I have to run outside for a bit and will be back after while. if it matters, X6 if a vlookup itself.
thank you
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I needed False. Thank you very much!
You're welcome. Glad to help.
Open in new window
The same formula can be written as below since all your calculations are same for currencies other than USD.
Open in new window