The Delivery Costs sheet should show $24 per delivery for the east route. Instead, E8 reads #DIV/0!. Use Error Checking to locate the cell, then follow its inputs to find out why it failed.

Trace the error to the delivery count

Open the relevant sheet in Ulet Sheets and choose Formulas > Error Checking. If Ulet reports that the workbook is still loading or that only the loaded region was checked, wait for loading to finish and run the command again. A workbook with several sheets needs a separate scan on each one you want to review.

In the example, E8 divides the freight charge in C8 by the delivery count in D8. C8 is 96 and D8 is 0. Check the dispatch sheet to see whether the route had zero deliveries or whether a count was left out.

Example Delivery Costs row with D8 set to zero and E8 showing #DIV/0! for =C8/D8.

Example trace. E8 uses the delivery count in D8 as its divisor.

Confirm the new number outside the scan

If the dispatch sheet shows four deliveries, enter that count in the working copy. Expect E8 to show 24 because 96 divided by 4 equals 24. Rerun Error Checking on the same sheet, then compare the cell result with the dispatch sheet. If zero deliveries was correct, the per-delivery cost is undefined. Use a workbook convention that makes that case visible.

A correction slip shows $96 divided by four deliveries equals $24 per delivery.

Example verification. Rerun the scan and check the calculation independently.

A formula can return a plausible number while pointing at the wrong row. For an important figure, keep the input check and the error scan as two separate checks.