Reply to thread

Message: <blockquote data-quote="Kasey" data-source="post: 2198023" data-attributes="member: 208919">I have two columns.  (A) is a prediction and (B) is an actual.  I need a formula for accuracy.  Right now I calculate the difference (A)-(B)=C and then calculate accuracy =1-(C/B)  This works fine unless the prediction is lower than the actual in which case the accuracy % is given as more than 100%.For example if the prediction is 14.5 and the actual is 15.15, the accuracy computes as 104.29%.  I understand that I can subtract that number from 200 to get 95.71 - the correct accuracy.  My question is how do I put all of that into one equation for a global formula for accuracy?  I don't want to have to go back and switch formulas on a case by case basis depending on the prediction being over or under the actual.</blockquote>