A report should tell the packing team which shipping totals need attention. In D2 calculate =B2*C2, where B2 is the parcel count and C2 is the unit cost. In E2 use =IFERROR(D2,"Check inputs").

Put a bad rate through the whole row

Use count 6 and type pending in the cost cell. D2 should show a formula error and E2 should display Check inputs. When you see the message, read the raw error in D2 before deciding whether the rate is missing or a reference broke.

The calculation and report cells sit side by side when the shipping rate is pending.

Illustrated error handling. Keep D2 available for diagnosis.

Confirm both a positive total and a real zero

Replace pending with 4 and expect 24. Then set the count to 0 and expect 0. This display rule catches errors. If a blank input is invalid but the calculation interprets it as zero, add an explicit completeness check.

Six packages at 4 each produce 24, and zero packages at 4 produce 0.

Illustrated control cases. A valid zero stays numeric.

Related Microsoft Excel reference