I have a spreadsheet with the following columns:

- Customer Name
- Amount Owed (Can be either $ or £)
- Amount Owed (£)

Unfortunately I am unable to make an IF statement recognise the $ or £
sign. Any quick tips on how this can be done without having to have a
separate column with the signs in. The IF statement would divide by the
rate (£1 = $1.7326) if it is dollars and would state the amount if it
was in pounds.

Any help would be appreciated.


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