Excel Information Functions:

Explained with Examples.

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Ultimate Project Management Template
Excel Template

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

• 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

Related Resource External VBA Reference