View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alex H Alex H is offline
external usenet poster
 
Posts: 3
Default 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""))))"