#SPILL! error

Copper Contributor

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.

1 Reply
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.