Information functions
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 NA() function returns the error value #N/A meaning "value is not available". Formula in cell B3: =NA() Excel Function […]
Use TYPE to find out what type of data is returned by a function or formula. Formula in cell C3: […]
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 […]
The SHEET function returns the sheet number of the cell reference sheet. Formula in cell D3: =SHEET(A1) Excel Function Syntax […]
The N function returns a value converted into a number. Formula in cell C3: =N(B3) The N function returns the […]
The INFO function returns information about the current operating environment, file path, number of active worksheets, Excel version etc. Excel […]
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 […]
The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number. Formula in cell C6: […]
The ISERR function returns TRUE if a cell returns an error, except error value #N/A. Formula in cell C6: =ISERR(B6) […]
The ISNA function returns TRUE if value is a #N/A error. Formula in cell C3: =ISNA(B3) Excel Function Syntax ISNA(value) […]
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 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 ISLOGICAL function
The ISLOGICAL function returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. Formula in cell C3: […]
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 […]
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 ISBLANK function
The ISBLANK function returns TRUE if the argument is an empty cell, returns FALSE if not. Excel Function Syntax ISBLANK(value) […]
The CELL function gets information about the formatting, location, or the contents of a cell. The formula example above in […]
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 […]
