Forum Discussion

Susan_Faust's avatar
Susan_Faust
Copper Contributor
May 05, 2023

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",LOWER([Content.AD'[Product Name']]))),TRUE,FALSE)

 

 

Formulas and Functions

4 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 05, 2023

    Susan_Faust 

    In Excel in Microsoft 365 or Office 2021, the formula will return an array of TRUE/FALSE values the same size as [Content.AD'[Product Name']] (are those apostrophes in the right place?)

    If that was not your intention, please explain what the formula should do.

    • Susan_Faust's avatar
      Susan_Faust
      Copper Contributor
      May 05, 2023
      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)


Resources