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.
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!
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
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python