ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   is there a percent error function in excel? (https://www.excelbanter.com/excel-worksheet-functions/44856-there-percent-error-function-excel.html)

syco1234

is there a percent error function in excel?
 
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" wrote in message
...
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?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=466648



All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com