HELP table causing function to spill

%3CLINGO-SUB%20id%3D%22lingo-sub-1714840%22%20slang%3D%22en-US%22%3EHELP%20table%20causing%20function%20to%20spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714840%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20doing%20an%20assignment%20for%20my%20computer%20apps%20class%20in%20Excel.%20I%20have%20an%20IF%20function%20in%20a%20column%2C%20which%20works%20when%20it%20is%20normal%2C%20but%20%22Spills%22%20when%20I%20convert%20the%20range%20into%20a%20table.%20All%20of%20the%20help%20I%20have%20found%20has%20told%20me%20to%20convert%20the%20table%20to%20a%20range%2C%20but%20I%20need%20it%20to%20be%20a%20table%20for%20credit%20on%20the%20assignment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1714840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715069%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20table%20causing%20function%20to%20spill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F809684%22%20target%3D%22_blank%22%3E%40ztolzmann%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20information%20you%20found%20is%20correct.%3C%2FP%3E%3CP%3EEither%20use%20a%20table%20with%20structured%20or%20regular%20references%20or%20use%20dynamic%20arrays%20but%20then%20without%20a%20table.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(%5B%40%5BQuantity%20in%20Stock%5D%5D%26lt%3B75%2C%22Order%22%2C%22OK%22)%0A%0A%3DIF(A15%26lt%3B75%2C%22Order%22%2C%22OK%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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