not sure what is wrong
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""))))"
|