CONTAINFORMULA

Returns a Boolean value which tells whether a range contains formula.

Syntax

CONTAINFORMULA(range_input, all_cells)

input_range - is the angle in radians for which you want the cotangent.

all_cells - Optional. Boolean argument, either TRUE or FALSE.
If TRUE, the formula returns TRUE only if all cells in range_input contain formula.
If FALSE, the formula returns TRUE if any cells in in range_input contain formula.
Default is TRUE if omitted.

Example

=CONTAINFORMULA(A1:D15) If all cells in range A1:D15 contain formula, returns TRUE.
Otherwise, FALSE.
=CONTAINFORMULA(A1:D15, TRUE) Same as above.
=CONTAINFORMULA(A1:D15, FALSE) If any cells in range A1:D15 contain formula, returns TRUE.
Otherwise, FALSE.
It means, if none of the cells in A1:D15 contain formula, returns FALSE.