View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rband rband is offline
external usenet poster
 
Posts: 5
Default 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")))