For a supplied value, the Excel TYPE function returns an integer that represents the value’s data type. Syntax:= TYPE (value) …
Category: Information function
The Excel SHEETS function returns the total number of sheets in a given reference. When no arguments are supplied SHEETS …
The Excel SHEET function returns the index number of a sheet in Excel. It will report the sheet number for …
The Excel NA function returns the #N/A error. #N/A means “not available” or “no value available”. You can nest the …
The Excel N function returns a number when given a value. The N function can be used to convert TRUE …
The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the …
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF …
The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return …
ISNUMBER in excel is a logical function in excel which we use to find out that if the target or …
The Excel ISNONTEXT function returns TRUE for any non-text value, for example, a number, a date, a time, etc. The …