Question: how do you calculate accuracy in excel?
Answer: Column A is Prediction. Actual value is in column B. In C column you will calculate forecast accuracy using Excel formula. Formula you need here is =IF($A2<$B2;$A2/$B2;$B2/$A2).