Understanding this formula:=IF(TC[[#This Row],[Page]]="/","Home",IF(TC[[#This Row],[Page]]="/blog/","Blog Home",IF(ISNUMBER(SEARCH("/blog/category/",T

[Pingbat]

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

 

[Pingbat]

Re: Understanding this formula:=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&am

Thank you for the training resource