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%.

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%.

Illustrated boundary checks. Keep above-target values visible.



