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

471 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

I check my work. I’ve yet to see excel make a mistake. When excel has given me the “wrong” answer it’s because I mistakenly asked it to answer the wrong question.

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