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