HELP table causing function to spill

[ztolzmann]

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 have found has told me to convert the table to a range, but I need it to be a table for credit on the assignment.

[#2]

@ztolzmann 

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")