Count lines that matched the record out of lines counted.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Stock accuracy
—
Formula
Correctly recorded lines ÷ Lines counted × 100
=IFERROR(B2/C2,0)Excel: B2 correctly recorded lines; C2 lines counted
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.