| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement based on currency format
I have a spreadsheet that has a column (column B) of numbers. Some of the
numbers are formatted in Euro currency and some are formatted in USD currency. I would like to put a formula in column C to automatically calculate the currency conversion of the Euro to USD. If cell B1 currency = Euro, then cell C1*1.45, else cell B1 Is there any way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency format in sort | Excel Discussion (Misc queries) | |||
| Put an if statement according to cell format | Excel Worksheet Functions | |||
| New column based on row cell format | Excel Discussion (Misc queries) | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| convert a numerical currency into word format | Excel Worksheet Functions | |||
Threaded Mode
