Generates a list of cells containing formulas that refer to textual cells as part of its calculation range. A textual cell is any cell that contains a string value such as: 'Results'.
Generates a list of cells containing formulas that produce a textual value. For example, the formula: '="Today is "&TEXT(NOW(),"dddd")' ...
Generates a list of cells containing formulas that refer to blank cells as part of its calculation range. A blank cell is ...
Generates a list of cells containing formulas that refer to external workbooks in their formulas. For example, a formula ...
Generates a list of cells containing formulas that refer to hidden cells as part of its calculation range. A hidden cell ...
Generates a list of cells containing formulas that refer to textual cells as part of its calculation range. A textual cell ...
Generates a list of cells containing formulas that start with a '+' character. For example, a formula such as: '=+B25' is ...
Generates a list of cells containing formulas that start with a '-' character. For example, a formula such as: '=-B25' is ...
Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as ...
Generates a list of cells containing formulas with nested IF() statements. This is an IF() statement inside of another IF() ...