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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" 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 |
#4
|
|||
|
|||
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" 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 |
Reply |
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) |