Find references to error cells

Find references to error cells

In Excel it is easy to build a formula, such as the IF formula, where one part of the formula is looking at a cell with an error in it, but as it is not being used at the moment, the error is not shown.

This test will highlight all those cells that may look correct at the moment but could give problems if there are changes.

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors