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