If statement for equivalent value of a range
 

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

If statement for equivalent value of a range
 

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
---------------
Jacob Skaria


"Rechie" wrote:

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

If statement for equivalent value of a range
 

=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

If statement for equivalent value of a range
 

Thanks Jacob, appreciate it.

Rechie



"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Rechie" wrote:

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

If statement for equivalent value of a range
 

Hi David,

It is working too, Thanks a lot for your support guys.

Rechie

"David Biddulph" wrote:

=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