ELi5: How does anyone know whether or not Excel gives the right answers to the functions and equations entered?

461 views

How can anyone know whether Excel is giving the right answer to anything that is more complex that one can do in one’s own head? I mean if I had to check every formula and function, I don’t need Excel, but couldn’t there be a bug that someone missed that returns an erroneous result in specific situations? That could be potentially catastrophic depending on what the data and results were used for.

In: 0

16 Answers

Anonymous 0 Comments

Excel has been used worldwide for performing calculations since 1985. Thats many millions of users, in universities, accountancy firms and government department, performing and checking its functions over 37 years. I call that rigorous testing.

You are viewing 1 out of 16 answers, click here to view all answers.