Menu
EXCEL ISFORMULA FUNCTION
Excel ISFORMULA Function Introduction
If a cell has a formula, this method returns TRUE; otherwise, it returns FALSE.
If the A1 cell has a formula like =SUM(A4:A5) or =A4+A5, for example, =ISFORMULA(A1) will return TRUE.
Excel 2013 is the first year that this feature is available.
Description of Excel ISFORMULA Function
Syntax:
=ISFORMULA(reference)
Parameter list:
A cell reference, a formula, or a term that relates to a cell can all be used to refer to the cell you wish to test.
Step By Step Guide of ISFORMULA Function
Example:
If cell is a cell with a formula, ISFORMULA returns TRUE. If the first cell in the range includes a formula, TRUE will be returned if cell contains a range of cells. FALSE will be returned for all other values.
Key Points
- A cell, a name related with a cell, or a range can all be referred to as a cell (multiple cells).
- In conditional statements, this function is most commonly used in combination with IF.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
