ISFORMULA

Test if cell contains a formula

Sponsored Link

ISFORMULA

Purpose 

Test if cell contains a formula

Return value 

TRUE or FALSE

Syntax 

=ISFORMULA (reference)

Arguments 

  • reference - Reference to cell or cell range.

Usage notes 

You can use the ISFORMULA function to test a cell to see if it contains a formula. ISFORMULA returns TRUE when a cell contains a formula and FALSE if not.

Remember that you can temporarily display all formulas in a worksheet with a keyboard shortcut.

To extract and display a formula, use the FORMULATEXT function.

Notes:

  • ISFORMULA was introduced in Excel 2013.

Sponsored Link

0 votes. 0 / 5