=IF(A1="EUR",B1*5.30,IF(A1="GB",B1*6.07,IF(A1="SEK ",B1*0.51,IF(A1="USD",B1*3.75,"result
undefined"))))
--
David Biddulph

"Rechie" wrote in message
...
Hi Specialist,

How can I get the Currency value of a range for below table:
Col A (Currency) Column B (Price)
EUR 100
GBP 150
SEK 125
USD 170

Results in In Column C should be: (Currency convertion to SAR)
If A1=EUR, then B1*5.30
If A1=GBP, then B1*6.07
If A1=SEK, then B1*0.51
If A1=USD, then B1*3.75

Thanks for your assistance.
Rechie