The following article introduces you to the ISFORMULA function - one of the functions in the information function group is very popular in Excel.
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?
- In the cell to calculate enter the formula : = ISFORMULA (C6)
- Press Enter -> return value is:
- 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:
- 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 :
- Where the value is not numeric -> the function returns the error value #VALUE!
Above are instructions and some specific examples when using ISFORMULA function in Excel.
Good luck!