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.

One batch has 100 labels printed, 90 passing visual inspection and 72 of those passing a rub test.

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.

The stage yields of 90 percent and 80 percent multiply to 72 percent, matching 72 labels out of the original 100.

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.

Microsoft’s Excel function reference