Forum Discussion

Elaine8692's avatar
Elaine8692
Copper Contributor
Apr 12, 2022

#SPILL! error

So when I applied a table with headers to my selected range (A14:G42) in my G column an #SPILL! error appears . I do have a formula in that column (=IF(A15:A42<75,"Order","OK"). I did use the Excel help options and it instructs me to Convert To Range. But when I do that it takes away my Design Table and all my options to format my table (like the total row option). I cant seem to figure out how to correct this error. Help Please.

excel
Formulas and Functions
office 365

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Apr 12, 2022
    You can't use a formula that returns multiple results in a structure table. You can change it to
    =IF(A15<75,"Order","OK")

    (or instead of A15, use a structured table reference - can just click the cell and excel will do that for you). Excel should extend the formula to the rest of the column automatically.