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

473 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 feel like this is the same as asking “how does my calculator do calculations right?”. If you input the formula right it will be interpreted and calculated right, like a calculator, that’s what it’s made to do.

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