At the packing bench, put Packed in B and Required in C. A kit with six packed and eight required is Short. With eight packed, it is Ready. This policy allows extras.

Check for missing counts before comparing

Enter this formula in D2 and copy it to the kit rows.

=IF(OR(B2="",C2=""),"Check input",IF(B2<C2,"Short","Ready"))

The outer IF asks for review if either count is empty. With both present, the inner IF compares the quantities.

With 6 packed and 8 required, the packing sheet shows Short.

Illustrated comparison with both inputs present.

Test blank, zero and an exact match

With C2 at 8, clear B2 and expect Check input. Type a real 0 and expect Short. Type 8 and expect Ready. If a data export can supply text or negative counts, validate those inputs separately before trusting the status.

A blank packed cell gives Check input while a recorded zero gives Short.

Illustrated boundary test for a kit requiring eight parts.

Related Microsoft Excel reference