Defective units out of those inspected.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Defect rate
—
Formula
Defective units ÷ Inspected units × 100
=IFERROR(B2/C2,0)Excel: B2 defective units; C2 inspected units
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.