Introduction:-
ISFORMULA function in excel is an information function. It is used to find out whether cells contain a formula or not. It returns TRUE if cell contains a formula otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required.
Syntax:-
=ISFORMULA(VALUE)
Arguments:-
- Value: It is the value which will be tested. It can be in form of an empty cell, an error, number, text, logical value etc.
Keynotes:-
- Values of the arguments in ISFORMULA function are not converted.
- This function can be used with functions like IF function, testing outcomes, locating errors etc.
- This function is available only after Excel 2013.
Examples
In this example, various formula values are entered in column B with some of them left without formula, and ISFORMULA function is used to find out which of them contain formula and which of them do not.
