You collected 18 crates toward a target of 24. Put the actual in B2 and the target in C2. Use =B2/C2 in D2 and format it as a percentage. The result is 75%.

Keep a missing or zero target visible

If the report requires both inputs to be numeric and the target to be positive, use =IF(OR(COUNT(B2:C2)<2,C2<=0),"Check inputs",B2/C2). A recorded actual of zero against 24 still gives 0%.

The actual count and positive target are visible beside the 75 percent result.

Illustrated ratio. Use counts from the same reporting period.

Try an above-target count

Change the actual to 30 in a copy. The result is 125% of target. To report the amount above target separately, use =(B2-C2)/C2 and label it 25% over target. Keep the numerical ratio available even if a progress bar stops at 100%.

A valid zero actual returns 0 percent, a zero target needs review, and 30 of 24 returns 125 percent.

Illustrated boundary checks. Keep above-target values visible.

Microsoft’s percentage examples