Forum Discussion
If statement returning "SPILL" error
I am using an IF statement to find the word "consulting" in a column of a table. I am receiving the #SPILL! error but cannot figure out why. Here is the formula: =IF(ISNUMBER(FIND("consulting",...
I do want it to display TRUE/FALSE. I have corrected the apostrophe to the below, but now i get a different error regarding apostrophe's and formulas.
=IF(ISNUMBER(FIND("consulting",LOWER('[Content.AD[Product Name]']))),TRUE,FALSE)
=IF(ISNUMBER(FIND("consulting",LOWER('[Content.AD[Product Name]']))),TRUE,FALSE)
Assuming that you're referring to a column in a table, simply remove the apostrophes.