[quote=bill k]Assuming that the $ sign or the pounds sign is a format issue.

=IF(CELL("format",(A2))="c2",A2/1.7326,A2)


this will check for the dollar sign

obviously you could enter the conversion rate in say cell D1,
and use the cell reference in the formula

=IF(CELL("format",(A2))="c2",A2/D1,A2)


--
bill k


Hi,

I have a similar problem. I have a list of companies and the states are listed. I have to convert the currencies into dollars for the states of british columbia and canada - using an IF statement. This is for an assignment at uni and any suggestions would greatly be appreciated.

Martin