Forum Discussion
HELP table causing function to spill
I am doing an assignment for my computer apps class in Excel. I have an IF function in a column, which works when it is normal, but "Spills" when I convert the range into a table. All of the help I h...
The information you found is correct.
Either use a table with structured or regular references or use dynamic arrays but then without a table.
=IF([@[Quantity in Stock]]<75,"Order","OK")
=IF(A15<75,"Order","OK")