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

467 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

Computers aren’t programmed with all the answers to functions they literally calculate the answers from the functions like inputting information into a calculator, so if the numbers and formula are entered correctly the answers will be to.

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