Description
The ISFORMULA Function is a conditional function that returns either TRUE or FALSE as result. Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text “FALSE”.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
In ISFORMULA if the referred cell contains a formula, it means the condition is met and the TRUE result will be returned. Similarly, if the value in the referred cell does not contain a formula , Excel will return “FALSE” as result.
Remember, if the provided syntax is not a reference to any cell, Excel will return the #NAME error.
=ISFORMULA(reference)
The ISFORMULA function’s syntax has the following argument:
- reference Required
The value is the cell reference that you want to test against the condition if the cell is the formula. This value shall be a reference to the other cell otherwise, Excel will return an error.
