The shelf label target is 100 mm with an allowed difference of 2 mm. Keep the direction of the difference visible and use its magnitude for the status.

Calculate the signed difference and the review flag

Put the measurement in B2, target 100 in F1, and tolerance 2 in F2. Use =B2-$F$1 in C2 and =IF(ABS(C2)>$F$2,"Review","Within tolerance") in D2. Keep all units in millimeters.

Both −3 and +3 exceed the 2 mm limit.

Illustrated two-sided difference. Keep the signed difference in its own cell.

Test the outside values and the exact edges

97 gives −3 and 103 gives +3, so both need review. 98 and 102 are within this strict comparison. Check blank readings separately, and inspect stored precision before treating a value displayed at the boundary as exactly on it.

The exact limits of 98 mm and 102 mm are accepted by the strict rule.

Illustrated boundary check. Change the comparison only if the process flags the boundary.

Microsoft’s ABS function reference