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