is there a percent error function in excel?

[syco1234]

is there? i can't seem to find one.

[Fred Smith]

What would be the error? The only one I can think of is division by zero, which
has its own error message.

--
Regards,
Fred


"syco1234" <[email protected]> wrote in message
news:[email protected]...
> is there? i can't seem to find one.

[MrShorty]

May depend on exactly how you are defining % error, but I don't think there's a built in % error function. I almost always use (calculated-actual)/actual, but I know there are other ways to represent error, too. How do you want to defing % error?