ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
The following article introduces you to the ISFORMULA function - one of the functions in the information function group is very popular in Excel.
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 1
Description: The function returns True if the cell refers to a cell containing the formula. Support functions from Excel 2013 onwards.
Syntax: ISFORMULA (reference)
Inside:
- reference: Reference to the cell to check, is a required parameter.
Attention:
- The function returns True value if it refers to the formula and vice versa, the function returns False value .
- If reference is invalid -> function returns error value #VALUE!
For example:
Is determining the values in the value a formula reference?
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 2
- In the cell to calculate enter the formula : = ISFORMULA (C6)
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 3
- Press Enter -> return value is:
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 4
- Here 9 is a number entered from the keyboard, so the function returns the value False.
- Similarly copying the formula for the remaining values results:
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 5
- Here cell value C7 = TODAY (), C8 = D6 in the form of a formula reference -> function returns True value .
- Where value is blank or not a formula -> function returns False value :
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 6
- Where the value is not numeric -> the function returns the error value #VALUE!
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel Picture 7
Above are instructions and some specific examples when using ISFORMULA function in Excel.
Good luck!
You should read it
- CELL function to look up information of a cell in Excel
- CELL function - The function returns information about the format or content of a cell in Excel
- ISBLANK function - The function checks if a cell is a blank value in Excel
- How to use the IF function in Excel
- How to use ADDRESS function in Excel
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
- How to use the Match function in Excel
- INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- How to convert formulas to values in Excel
- How to use the IFS function in Excel 2016
- The Match function (the function searches for a specified value in an array or cell range) in Excel
May be interested
ISLOGICAL function - The function returns True if the value is a logical value in Excel
ISNA function - The function returns True if the value is an # N / A error value in Excel
ISNONTEXT function - The function returns True if the value is not a text value in Excel
ISNUMBER function - The function returns True if the value is numeric in Excel
ISODD function - The function returns True if the value is an odd number in Excel
ISREF function - The function returns True if the value is a valid reference value in Excel