Why double quotes?

Try

=IF(LEFT(RC3,5)="01752","Local",IF(LEFT(RC3,5
etc.

--
Greetings from New Zealand

"Alex H" wrote in message
...
Hi i have the following code for a cell, but if I enter 01752 into RC3,5
I am getting "Long distance". Can someone tell me what I'm doing wrong

thanks
A

"=IF(LEFT(RC3,5)=""01752"",""Local"",IF(LEFT(RC3,5 )=""01548"",""Local"",IF(LEFT(RC3,5)=""01803"",""L ocal"",IF(LEFT(RC3,5)=""0845"",""Local"",""Long
Distance""))))"