How to check for different kinds of potential formula errors?

The DQ Assistant identifies the following types of potential formula issues:

​

(Please click the links to open the respective pages)

​

• Inconsistent formula range

• Fixed value in formula range

• Error in formula

• References to empty cells (can be activated in the settings menu)

• Rounding deviations (can be activated in the settings menu)

• Hard-coded values in formula (can be activated in the settings menu)

• References to other workbooks (can be activated in the settings menu)

​

Potential formula issues will always be shown in the Add-in window: