Three rows report stock remaining after items are issued. All three results might look right today, even if someone typed one of them by hand.

Expose the calculation column

In Ulet choose Formulas → Show Formulas. Here C2 shows =A2-B2, C3 shows 8, and C4 shows =A4-B4. Check the notes or ask the sheet owner whether C3 is an intentional adjustment before editing it.

Show Formulas exposes the hard-coded 8 between relative subtraction formulas.

Illustrated formula inspection. A displayed 8 can also be the correct calculated result.

Give the repaired row an input that changes

If all three rows should follow the same rule, enter =A3-B3 in C3 and turn Show Formulas off. With A3 set to 12 and B3 set to 4, the result should be 8. In a copy, change B3 to 5 and expect 7. This catches a repeated hard-coded result as well as a reference to the wrong row.

The repaired C3 references A3 and B3 and changes to 7 when B3 increases to 5.

Illustrated change test using a single row.

Microsoft Excel instructions