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) […]

How to use the NA function

The NA() function returns the error value #N/A meaning "value is not available". Formula in cell B3: =NA() Excel Function […]

How to use the TYPE 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 […]

How to use the SHEET 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 N function

The N function returns a value converted into a number. Formula in cell C3: =N(B3) The N function returns the […]

How to use the INFO function

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 […]

How to use the ISODD function

The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number. Formula in cell C6: […]

How to use the ISERR function

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 ISNA function

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 ISREF function

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) […]

How to use the CELL function

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 […]