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

483 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

You know excel gets the right answers all the time because it’s the product of 30 years of development, tens of thousands of programmers, hundreds of professional bug testers, and billions (literally) of users refining it into what it is today. The basic functions have been mastered 30 years ago by every spreadsheet software. Whenever a function haven’t worked properly, someone fixed it and everyone adopted the fix.

Essentially, software like excel or Google Sheets didn’t come out of nowhere. They’re built on a solid foundation, running on reliable machines, and they aren’t trying to reinvent the wheel.

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