If statement for equivalent value of a range

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
 
J

Jacob Skaria

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
 
D

David Biddulph

=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"))))
 
R

Rechie

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...
 

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 statement for cell ranges to equivalent value 2
If statement for a range of cells 3
Saving a range for later reference 0
Match a currency with its corresponding value 4
Show value from one cell in another cell if today falls between a date range 5
Combining SUMIF and SUBTOTAL 4
Find string from column A in Range("B2:F7") list the header of that column/s 5
finding is a value is betwen a range of values 5

Top