Find Formulas with no reference to other cells

Find Formulas with no reference to other cells

If you have an Excel formula that contains no references to other cells e.g. it says


you run the risk that these numbers are incorrect.

Who typed them in and what are they based on? Remember, good practice suggests that inputs should be in their own cell so that you can see what is driving your spreadsheet. In this case it look like this one cell should be in 3 seperate cells, clearly marked as input cells.

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