Generates a list of cells containing formulas that produce a textual value. For example, the formula: '="Today is "&TEXT(NOW(),"dddd")' will produce a textual value for the cell.
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 ...
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 ...