How to Calculate Accuracy Percentage in Excel (3 Methods)

Assume you have the following dataset. It contains the forecasted demand units and actual demand units for products.

How to Calculate Accuracy Percentage in Excel


Method 1 – Calculate Accuracy Percentage with Excel ABS Function

  • Enter the following formula in the first cell of your Accuracy column.
=1-ABS(C5/D5-1)
  • Click on the % icon on the Home Ribbon to apply the percentage number format.
  • Double-click on the Fill Handle icon or drag it down to apply the formula to the cells below.

Calculate Accuracy Percentage with Excel ABS Function

Read More: Make an Excel Spreadsheet Automatically Calculate Percentage


Method 2 – Compute Accuracy Percentage with the IF Function

  • Enter the following formula in the first cell of your Accuracy column.
=1-IF(C5>D5,(C5-D5)/D5,(D5-C5)/D5)
  • Click the % icon on the Home Ribbon to apply the percentage number format.
  • Double-click on the Fill Handle icon or drag it down to apply the formula to the cells below.

Calculate Accuracy Percentage with Excel IF Function


Method 3 – Use the MIN-MAX Combination to Calculate Accuracy Percentage

  • Enter the following formula in the first cell of your Accuracy column.

=1-(MAX(C5:D5)-MIN(C5:D5))/D5

  • Click the % icon on the Home Ribbon to apply the percentage number format.
  • Double-click on the Fill Handle icon or drag it down to apply the formula to the cells below.

Read More: How to Calculate Win-Loss Percentage in Excel


Errors in Accuracy Percentage Calculations

When the Forecast data is much different than the Demand value, this can result in a negative or zero accuracy percentage.

In this case, calculating the error percentage can be better than figuring the Accuracy Percentage.

  • If the Demand value becomes zero, then Excel will show the #DIV/0! Error.

Read More: How to Calculate Error Percentage in Excel


Things to Remember

  • You must use the actual value (Demand) in the denominator in the formula while calculating the accuracy percentage.
  • Make sure to use parentheses and brackets properly in formulas.

Download Practice Workbook

You can download the practice workbook from the download button below.


Related Articles


<< Go Back to Percentage Formula ExamplesCalculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo