Out of 100 printed labels, 90 pass visual inspection. The rub test accepts 72 of those 90. What share of the original batch can ship? The second stage starts with a smaller group, so track the denominator on each row.
Record what enters and leaves each stage
Use B for entered and C for passed. Put 100 and 90 on row 2, then 90 and 72 on row 3. In D2, enter =C2/B2 and fill it down. Format the results as percentages. A stage with no entries needs separate handling because there is no rate to calculate.

Illustrated batch counts. The second stage begins with the first stage’s survivors.
Multiply and reconcile with the head count
=PRODUCT(D2:D3)The stage yields are 90% and 80%. Their product is 72%, which agrees with 72 ÷ 100. Use the unrounded values in the formula even if the sheet displays fewer decimals.

Illustrated reconciliation. The final denominator is the original batch.
This check works when the same batch moves through both stages with no new units added. If a stage adds replacements, rework or a separate batch, record those flows explicitly before interpreting a combined yield.



