Excel FunctionsExcel ISFORMULA Function



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.


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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.