The preparation sheet needs four sets of six parts and two spares for the whole order. The expected count is 26. A formula reports 32.
Inspect the selected cell’s intermediate expressions
In Ulet choose Formulas → Evaluate formula and Inspect selected cell. Use Next step and Previous step to review the operations. If the formula is =B2*(C2+D2), the grouped expression becomes 8 before multiplication by 4.

Illustrated calculation plan. Confirm whether spares belong to the whole order.
Check the business rule and the corrected result
If the two spares apply once to the whole order, use =B2*C2+D2. That gives 24 for the sets and 26 overall. If the panel cannot evaluate part of the expression, calculate that part in a scratch cell and compare it to the source.

Illustrated evaluation check. Inspect the steps before changing the formula.



