Monday, May 10, 2021

Sorry, Your Spreadsheet Has Errors (Almost 90% Do)

 

Various studies report that nearly 9 out of 10 spreadsheets (88%) contain errors. A majority of these errors were from human error (and could have been avoided). This article lists famous examples of spreadsheet blunders and how companies can avoid spreadsheet error in the future.

You may want to pause before hitting “send” on your next Excel masterpiece: Various studies over the past few years report that 88 percent of all spreadsheets have "significant" errors in them. Even the most carefully crafted spreadsheets contain errors in 1 percent or more of all formula cells. A majority of errors reported were caused by human error—meaning they could have been completely avoidable mistakes.