| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
DIFFERENT CURRENCY FORMATS IN FORMULA
I HAVE 6 DIFFERENT CURRENCIES AND NEED TO PUT THESE CURRENCIES IN A FORMUAL
SO THAT THE AMOUNT PAID HAS ITS CORRECT CURRENCY SYMBOL. THE CURRENCIES ARE $USD, $CAD, $AUD, $NZD, ぎ EURO and ﾂ｣ GBP. IS THERE ANY WAY EXCEL WOULD ALLOW ME TO PUT THESE CURRENCIES IN A FORMULA SO THAT THE CORRECT SYMBOL IS ENTERED. EG IF CELL A5 SHOWED EURO AND CELL E5 HAD THE FOLLOWING FORMULA =IF(B5=PAPER,C5*D5,0). CAN I ENTER FORMATTING FOR THIS TO SHOW RESULT ぎ EURO 20-00 INSTEAD OF JUST 20-00 THANK YOU |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listing data without blank rows | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| Help with array formula | Excel Worksheet Functions | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
