How to use the ISREF function
The ISREF function returns TRUE if value refers to a reference.
Formula in cell C3:
Excel Function Syntax
ISREF(value)
Arguments
value | Required. The value you want to check for a reference. |
Functions in 'Information'
The ISREF function function is one of many functions in the 'Information' category.
The CELL function gets information about the formatting, location, or the contents of a cell. The formula example above in […]
How to use the ERROR.TYPE function
The ERROR.TYPE function returns a number that represents one of the error values in Excel. Formula in cell C3: =ERROR.TYPE(B3) […]
The INFO function returns information about the current operating environment, file path, number of active worksheets, Excel version etc. Excel […]
How to use the ISBLANK function
The ISBLANK function returns TRUE if the argument is an empty cell, returns FALSE if not. Excel Function Syntax ISBLANK(value) […]
The ISERR function returns TRUE if a cell returns an error, except error value #N/A. Formula in cell C6: =ISERR(B6) […]
How to use the ISERROR function
The ISERROR function returns TRUE if a cell returns an error. Formula in cell D3: =ISERROR(B3) Excel Function Syntax ISERROR(value) […]
How to use the ISFORMULA function
The ISFORMULA function returns TRUE if a cell contains a formula, FALSE if text, number or boolean value. Formula in […]
How to use the ISLOGICAL function
The ISLOGICAL function returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. Formula in cell C3: […]
The ISNA function returns TRUE if value is a #N/A error. Formula in cell C3: =ISNA(B3) Excel Function Syntax ISNA(value) […]
How to use the ISNONTEXT function
The ISNONTEXT function returns TRUE if value is not text, also returns TRUE if cell is empty. Formula in cell […]
How to use the ISNUMBER function
The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Formula in cell D3: =ISNUMBER(B3) Excel […]
The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number. Formula in cell C6: […]
The ISREF function returns TRUE if value refers to a reference. Formula in cell C3: =ISREF(B3) Excel Function Syntax ISREF(value) […]
How to use the ISTEXT function
The ISTEXT function returns TRUE if value is text. Formula in cell C3: =ISTEXT(B3) Excel Function Syntax ISTEXT(value) Arguments value […]
The N function returns a value converted into a number. Formula in cell C3: =N(B3) The N function returns the […]
The NA() function returns the error value #N/A meaning "value is not available". Formula in cell B3: =NA() Excel Function […]
The SHEET function returns the sheet number of the cell reference sheet. Formula in cell D3: =SHEET(A1) Excel Function Syntax […]
How to use the SHEETS function
The SHEETS function returns the number of sheets in a reference. It returns the number of sheets in a workbook if […]
Use TYPE to find out what type of data is returned by a function or formula. Formula in cell C3: […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form