I need to switch currencies based on a pull-down selection
Thanks, I'll play around and see what I can come up with.
"Glenn" wrote:
rband wrote:
Spiky, thanks but I guess I didn't explain myself clearly. I understand what
you've suggested and actually I already had that in the spreadsheet. What I
am attempting to do is to take a column of numbers formatted as currency in
US dollars and whan I select pounds or euros, the calculation works fine I
just want the symbols to change to either pounds or euros. Thanks for the
help and sorry I wasn't clearer.
Some variation of the following could work:
=IF(B1="Pounds",TEXT(A1,"[$£-809]#,##0.00"),IF(B1="Euros",TEXT(A1,"[$‚¬-2]
#,##0.00"),TEXT(A1,"$#,##0.00")))
|