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.

The intended calculation multiplies four by six before adding two.

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.

The parentheses make the two spares part of each set.

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

Microsoft’s reference for evaluating nested formulas