| 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 |
| 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 | |||
Threaded Mode
