Create a lookup table of currency name and how you want display it, and use
=IF(test,VLOOKUP(C5,M1:N6,2,False)&" "&TEXT(result,"#,##0.00"),0).
--
HTH
RP
(remove nothere from the email address if mailing direct)
"BAZZA" wrote in message
...
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
|