In MS Excel, I have three cells: a Prediction cell (A1), Results cell (B1), and Difference cell (C1). I have a cell called Accuracy (D1) where I would like to display the accuracy of the prediction made in light of the outcome.
As an illustration, if I forecast 24 and get 24, the accuracy should be 100% with a difference of 0. The accuracy should be 50% with a differential of -12 if I have a prediction of 24 and an outcome of 12. The accuracy should be 50% with a differential of 12 if I have a prediction of 24 and an outcome of 48.
Here is the calculation I'm using in the Accuracy cell (D1):
This calculation is only showing the expected results when the Prediction cell is higher than or equal to the Results cell.