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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

Thank you for your suggestion I will try it

"Bob Phillips" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

I have tried your formual and it works thanks very much for your help.

Could I ask you another question please.

If I had the same lookup table product coulmn 1 currency symbol column 2 and
currency text in column. is there anyway i can get coulmn 2 and 3 to appear
in sheet 1 when i enter an amount. e.g. if a product was sold for two euro
and i had to enter 2 in cell f8 is there something i could enter so that it
appears as € euro 2-00.
If you cannot help then thanks for your help on the previous.


"Bob Phillips" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>