| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement for cell ranges to equivalent value | Excel Discussion (Misc queries) | |||
| Is SET Statement only for Range? | Excel Discussion (Misc queries) | |||
| IF Statement with a range | Excel Worksheet Functions | |||
| HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)? | Excel Worksheet Functions | |||
| CASE statement equivalent | Excel Worksheet Functions | |||
Linear Mode
