ISFORMULA

Rational

Check if a cell contains a formula

Description

The Excel ISFORMULA function check if a specified cell is containing a formula and returns “TRUE” when a cell consists of formula, and “FALSE” when a cell does not have a formula.
For example cell C6 contains =2+2, “=ISFORMULA(C6)” returns TRUE as the cell containing a formula.

Syntax

=ISFORMULA( reference )

Parameters

value – Refer cell to check if contain a formula.

Return Value

A Boolean value (TRUE or FALSE)

Key Notes

  • The ISFORMULA cell is useful in finding a formula or blank cell within a large data set.
  • ISFORMULA function returns the #VALUE! error value in case reference is not a valid data type.
  • The ISFORMULA formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

Check if a cell is blank in Excel

ISBLANK

The ISBLANK function checks if a cell is blank and returns “TRUE” when it is, I.e., “=ISBLANK(“Text”)” return FALSE as the cell contains some value “Text”.

Read More »
Check if cell returns a logical value in Excel

ISLOGICAL

The ISLOGICAL function check if a specified cell has Boolean value and returns “TRUE” when a cell has a Boolean data type, and “FALSE” if it does not.

Read More »
Check a cell for valid reference in Excel

ISREF

The ISREF function checks if a cell has a correct reference, returns “TRUE” when a cell has a valid reference, and “FALSE” for reference error or not linked.

Read More »