Share Post
Excel Information Functions:
Explained with Examples.
- CELL: CELL is an Information Function. CELL Function in Excel returns information about the contents, formatting or location of a given cell
- TYPE: TYPE is an Information Function. TYPE Function in Excel returns information (integer) about the data type of a supplied value
- NA: NA is an Information Function. NA Function in Excel returns excel #NA Error
- N: N is an Information Function. N Function in Excel converts data into numeric values, converts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0
- ERROR.TYPE: ERROR.TYPE is an Information Function. ERROR.TYPE Function in Excel returns error number of the given error value, returns #NA if the given value is not an error
- ISNUMBER: ISNUMBER is an Information Function. ISNUMBER Function in Excel returns TRUE if the given value is a number, otherwise returns FALSE
- ISTEXT: ISTEXT is an Information Function. ISTEXT Function in Excel returns TRUE if the given value is a string/text, otherwise returns FALSE
- ISREF: ISREF is an Information Function. ISREF Function in Excel returns TRUE if the given value is a reference, otherwise returns FALSE
- ISNA: ISNA is an Information Function. ISNA Function in Excel returns TRUE if the given value is #NA, otherwise returns FALSE
- ISLOGICAL: ISLOGICAL is an Information Function. ISLOGICAL Function in Excel returns TRUE if the given value is logical (TRUE or FALSE), otherwise returns FALSE
- ISERROR: ISERROR is an Information Function. ISERROR Function in Excel tests if given value is an error or not(is considers #N/A as an error) and returns TRUE if it finds error;otherwise returns FALSE
- ISERR: ISERR is an Information Function. ISERR Function in Excel tests if given value is an error or not(EXCEPT for the #N/A error) and returns TRUE if it finds error;otherwise returns FALSE
- ISBLANK: ISBLANK is an Information Function. ISBLANK Function in Excel tests if given value or Cell is a Blank or not and returns TRUE if the value is blank;otherwise returns FALSE
- ISEVEN: ISEVEN is an Information Function. ISEVEN Function in Excel returns TRUE if the given value is even
