The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing

URL:  http://boards.fool.com/88-of-spreadsheets-have-errors-30641740.aspx

Subject:  88% of spreadsheets have errors Date:  4/18/2013  2:18 PM
Author:  tjscott0 Number:  72064 of 76418

http://www.marketwatch.com/story/88-of-spreadsheets-have-err...

Microsoft Excel makes it easy for anyone to do the kind of number crunching once reserved for accountants and statisticians. But the world’s best-selling spreadsheet software has also contributed to the proliferation of bad math.

Close to 90% of spreadsheet documents contain errors, a 2008 analysis of multiple studies suggests. “Spreadsheets, even after careful development, contain errors in 1% or more of all formula cells,” writes Ray Panko, a professor of IT management at the University of Hawaii and an authority on bad spreadsheet practices. “In large spreadsheets with thousands of formulas, there will be dozens of undetected errors.”


Such mistakes not only can lead to miscalculations in family budgets and distorted balance sheets at small businesses, but also might result in questionable rationales for global fiscal policy

Copyright 1996-2014 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us