May 05 2023 08:00 AM
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)
May 05 2023 08:09 AM
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.
May 05 2023 08:11 AM
May 05 2023 08:20 AM
May 05 2023 08:28 AM
Assuming that you're referring to a column in a table, simply remove the apostrophes.