Hi from sunny 16 degrees C york UK,
I would to make sure i understand this formula applied to the table below:
=IF(TC[[#This Row],[Page]]="/","Home",IF(TC[[#This Row],[Page]]="/blog/","Blog Home",IF(ISNUMBER(SEARCH("/blog/category/",TC[[#This Row],[Page]])),"Blog Category",IF(ISNUMBER(SEARCH("/blog/",TC[[#This Row],[Page]])),"Blog Post","Other"))))
Ok so here are my question:
1: Why is function "IF(ISNUMBER" introduced later in the formula when earlier in the formula it's not needed
Thanks in advance,
David
I would to make sure i understand this formula applied to the table below:
=IF(TC[[#This Row],[Page]]="/","Home",IF(TC[[#This Row],[Page]]="/blog/","Blog Home",IF(ISNUMBER(SEARCH("/blog/category/",TC[[#This Row],[Page]])),"Blog Category",IF(ISNUMBER(SEARCH("/blog/",TC[[#This Row],[Page]])),"Blog Post","Other"))))

Ok so here are my question:
1: Why is function "IF(ISNUMBER" introduced later in the formula when earlier in the formula it's not needed
Thanks in advance,
David