Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 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 »
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 »