What is EXCEL ISFORMULA FUNCTION
The Excel ISFORMULA Function is listed under Microsoft Excel's Information Functions category. It returns TRUE is the value supplied (or the referred cell) has a formula and if their not formula in the cell it returns a FALSE.
How to use it
To learn how to use the ISFORMULA function in Excel, you need to understand its syntax and arguments:
- reference: A cell reference that you want to evaluate.
- If cell reference is not a valid reference it will return #VALUE!.
- You can also use the shortcut key Control + ~ to display all the formula in a worksheet.
To master the ISFORMULA function we need to try it out in an example, so make sure to check out the below one:
Below we have used different arguments:
- A simple addition calculation and it returns TRUE.
- A volatile function and it returns TRUE.
- One thing you have to note that ISFORMULA is concerned with the formula in a cell not with the result of a formula. It will return TRUE even if the result of the formula is empty or an error.
- If there is any value other than formula in a cell it will return FALSE.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL CELL Function
- EXCEL ERROR.TYPE Function
- EXCEL INFO Function
- EXCEL ISBLANK Function
- EXCEL ISERR Function
- EXCEL ISERROR Function
- EXCEL ISEVEN Function
- EXCEL ISLOGICAL Function
- EXCEL ISNA Function
- EXCEL ISNONTEXT Function
- EXCEL ISNUMBER Function
- EXCEL ISODD Function
- EXCEL ISREF Function
- EXCEL ISTEXT Function
- EXCEL N Function
- EXCEL NA Function
- EXCEL SHEET Function
- EXCEL SHEETS Function
- EXCEL TYPE Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.