Generates a list of cells containing formulas with errors. On the spreadsheet, Excel will show the value of these cells as one of the standard error indicators (#NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM!, or #N/A).
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() ...
Generates a list of cells containing numeric values that have been formatted as text. This will also include values that ...
Generates a list of cells containing text that looks like a formula (starts with an equals sign), but is formatted as text ...
Generates a list of cells containing unique formulas. Unique formulas are formulas that exist only once within the workbook, ...