Generates a list of cells containing formulas that are inconsistent with its neighboring cells. For example, if a row is used to generate subtotals for several columns, and one of the formulas amongst the subtotals contains an inconsistency with its referral range, this cell will be reported.
Generates a list of cells containing any formula with a numeric constant as part of its formula. For example, =SUM(A3:B7)*25.2 ...
Generates a list of cells containing any formula with a textual constant as part of its formula. For example, ="Hello world" ...
Generates a list of cells containing array formulas. On the spreadsheet, Excel will show arrays formulas with surrounding ...
Generates a list of cells containing duplicate formulas. Duplicate formulas are formulas that are duplicated one or more ...
Generates a list of cells containing formulas that are inconsistent with its neighboring cells. For example, if a row is ...
Generates a list of cells containing formulas that do not refer to other cells. For example, the formula: '=5*2' does not ...
Generates a list of cells containing formulas that produce a date/time value. For example, the formula: '=NOW()' will produce ...
Generates a list of cells containing formulas that produce a logical value. For example, the formula: '=TRUE' produces a ...
Generates a list of cells containing formulas that produce a numeric value. For example, the formula: '=SUM(A1:C1)' will ...