If statement for equivalent value of a range

  • Thread starter Thread starter Rechie
  • Start date Start date
R

Rechie

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
 
Suppose you have the rates in Sheet2 A1:B4

With EUR in A1
=B1*VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0)

If this post helps click Yes
 
=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"))))
 
Thanks Jacob, appreciate it.

Rechie



Jacob Skaria said:
Suppose you have the rates in Sheet2 A1:B4

With EUR in A1
=B1*VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0)

If this post helps click Yes
Click to expand...
 
Back
Top