Currency Formatting

C

chalky

I currently have a formula that changes the currency of a figure based
on a column heading that denotes a currency code. This formula works
perfectly but i want to be able to change the format dependent on which
currency i select. I.e when i change from € to USD not only do i want
the value to change, i want the appearence to change to $#,##0.

I dont want to do this with a macro - any ideas?
 
C

CLR

If you can accept the result as TEXT, then a variation of the following
should do as you wish.............

=IF(A1="US",TEXT(YourFormulaHere,"$#,##0"),YourFormulaHere)

You can add more "IF" levels as needed......

Vaya con Dios,
Chuck, CABGx3
 
Top