Thread: nested if contains a syntax error because of a "."
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default nested if contains a syntax error because of a "."
IS this what you mean ...

=IF(LEFT(C2,4)="ur01","12.13.145.166",IF(LEFT(C2,4 )="ur02","12.13.145.167",IF(LEFT(C2,4)="ur03","13. 12.145.168","")))

"Janis" wrote:

=if(left(C2,4),ur01,12.13.145.166,if(left(C2,4),ur 02
,12.13.145.167,if(left(C2,4) ,ur03,13.12.145.168, ""), ""), "")

I want to put the right IP address in the cell if if the Cn cell matches the
right modem. It is stopping on the modem number, is that because there is a
"." in the IP number? How can I escape it?

tia,
Reply With QuoteReply With Quote