This function tests whether a value, an expression, or contents of a reference cell is a formula.

Syntax

ISFORMULA(reference)

Arguments

Specify the cell reference for the argument.

Remarks

This function returns FALSE if the value refers to an empty cell or to no data.

This function is used to test the contents of a cell.

Data Types

Accepts cell reference for argument. Returns Boolean (TRUE or FALSE) data.

Examples

ISFORMULA(B4) returns false, where B4 is a cell reference with a numeric value 56.