ISREF function - The function returns True if the value is a valid reference value in Excel
The following article introduces you to the ISREF function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is a valid reference value. Application function to check if the value is a reference value or not.
Syntax: ISREF (value)
Inside:
- value: The value you want to check is a reference or not, is a required parameter.
Attention:
- The function returns True if the value is a reference and vice versa the function returns False.
For example:
Is determining the value in value a reference?
- In the cell to calculate enter the formula : = ISREF (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Here if value is blank -> the function returns True.
- Where is not a reference -> enter the formula: = ISREF ("Excel.net")
- Press Enter -> function returns False value :
Above are instructions and some specific examples when using the ISREF function in Excel.
Good luck!
You should read it
- SHEETS function - The function returns the number of pages in a reference in Excel
- How to use the IFS function in Excel 2016
- ISODD function - The function returns True if the value is an odd number in Excel
- How to use ADDRESS function in Excel
- ISNONTEXT function - The function returns True if the value is not a text value in Excel
- ISTEXT function - Function returns True value if that value is text in Excel
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
- The function dir () in Python
May be interested
- The OFFSET function returns a reference in Excelthe offset () function returns a reference to a range, a cell or a range of cells with the number of rows and columns specified by you. the return reference can be a cell or a range of cells that you can specify the number of rows and columns to return.
- ISEVEN function - Function returns True value if the value is even in Exceliseven function: the function returns true if the value is even in excel. syntax: iseven (value)
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- ISNA function - The function returns True if the value is an # N / A error value in Excelisna function: the function returns true if the value is an # n / a error value in excel. syntax: isna (value)
- ISERROR function - The function returns True if the value is any error in Exceliserror function: the function returns true if the value is any error in excel. syntax: iserror (value)
- ISLOGICAL function - The function returns True if the value is a logical value in Excelislogical function: the function returns true if that value is a logical value in excel. syntax: islogical (value)
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- ISERR function - Function returns True if the value is any error except # N / A error in Exceliserr function: the function returns true if the value is any error except # n / a error syntax: iserr (value)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)