Forum Discussion
#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 h...
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.
=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.