Category: Information function

For a supplied value, the Excel TYPE function returns an integer that represents the value’s data type. Syntax:= TYPE (value) The TYPE function syntax has …

The Excel SHEETS function returns the total number of sheets in a given reference.  When no arguments are supplied SHEETS returns the total number of …

The Excel SHEET function returns the index number of a sheet in Excel. It will report the sheet number for a cell reference, named range, …

The Excel NA function returns the #N/A error. #N/A means “not available” or “no value available”. You can nest the NA function inside a formula …

The Excel N function returns a number when given a value. The N function can be used to convert TRUE and FALSE to 1 and …

The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the ISTEXT function to check if …

The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF function to check if a …

The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return the #VALUE error when a …

ISNUMBER in excel is a logical function in excel which we use to find out that if the target or the cell being referred to …

The Excel ISNONTEXT function returns TRUE for any non-text value, for example, a number, a date, a time, etc. The ISNONTEXT function also returns TRUE …