The #REF error occurs in Microsoft Excel when a formula refers to an invalid cell. This usually happens when cells that were referenced by formulas get removed or ...

Studies, including those by spreadsheet researcher Raymond Panko, estimate that up to 90% of all spreadsheets contain at ...