Column A of my spreadsheet has several amounts formatted in either US$,
Pound Sterling, Euro, Swedish Krona, or Swiss Franc. (I used the Format -
Number - Currency - Symbol for each amount. I am actually using the
currency symbol rather than the ISO abbreviation for each currency, but I
could switch to the ISO currency abbreviation if it makes things easier...)

Now I want to create a formula in Column B that does something depending on
the type of currency in each row of Column A.
How do I detect the correct kind of currency that is in Column A so that I
can build my formula correctly? (It will be an =IF() function.)

Hopefully, this can be done without a macro as I have problems running them
due to high security settings.

Thanks.
--
tb