All articles with '# REF error' Tag

Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]

Published on Jan 18, 2012 in Financial Modeling, Learn Excel
Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]

This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]

Continue »

Excel Formula Errors – Understand and Debug Them

Published on Apr 20, 2009 in All Time Hits, Excel Howtos, Featured, Learn Excel
Excel Formula Errors – Understand and Debug Them

In this installment of spreadcheats we will learn how to understand excel formula errors and fix them. The #DIV/0!, #NAME?, #N/A, #NULL!, #NUM!, #REF!, #VALUE! errors and how to fix them.

Continue »