d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Excel Formula
Add Reply New Topic New Poll
Member
Posts: 19,115
Joined: Mar 22 2007
Gold: 1,242.00
Aug 18 2023 10:39am
What’s up everyone. I have a question in regards to some work I’m doing. I need to get the total accuracy.

Here is the problem:

I have -

Expected Number
Actual Number

The difference between the expected and actual number are both positive and negative variances

Currently I turned both positive and negative numbers to absolute values.

The formula I am using = 1 - (variance(Absolute)/expected number) * 100%

Is this the correct way to get the total accuracy?
Go Back To Computers & IT Topic List
Add Reply New Topic New Poll