Anonymous
Anonymous asked in Computers & InternetSoftware · 1 decade ago

Excel percent error function

Is there a function in excel where i can calculate the percent error.

3 Answers

Relevance
  • Elmyr
    Lv 7
    1 decade ago
    Favorite Answer

    There's no formula for it in Excel, but if the expected result is in A1 and the actual result is in B1, the formula in C1 is just:

    =ABS((A1-B1)/A1)

    If I understand your question correctly.

    Edit:

    I guess if you really wanted to, you could make a UDF. alt+F11 opens the VB editor. Insert > Module and paste the code below in the window that opens.

    Public Function PercentError (byVal Expect As Long, byVal Actual As Long) As Double

    PercentError = Abs((Expect - Actual) / Expect)

    End Function

    The formula in C1 would then be =PercentError(A1,B1)

    • Login to reply the answers
  • herek
    Lv 4
    3 years ago

    Percent Function In Excel

    • Login to reply the answers
  • 3 years ago

    Percent Of Error Calculator

    • Login to reply the answers
Still have questions? Get your answers by asking now.