Bill has a good idea, however 'C2' simply means Currency, 2 decimals.
It does not look at WHAT currency symbol is displayed. This method
will not meet your needs.

When you Format a cell to display either one or the other currency
symbols, technically, the cell is numeric and doesn't really contain
either sign (check the formula bar for the exact contents of the
cell).

My best solution would be the use of a helper column (named "Currency
Type") to hold a value to signify the type, e.g. 'D' or 'P').

You can then use an IF statement to test the helper cell for either D
or P and achieve the desired outcome.

=IF(C1="D", B1/1.7326,B1)

Format this cell as Currency/pound

NOTE: as the exchange rate fluctuates, you may also want to put that
rate in another cell (E1) and change your formula to:

=IF(C1="D", B1/E1,B1) then just update E1 when the rate changes and
all your formulas will show the current value.

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477639