Information

Home/Excel Formulas/Information

Excel Information Functions:

Explained with Examples.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

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
LIMITED TIME OFFER

Related pages


how to unprotect cells in excelexcel vba endvb scripting in exceltemplate excel project timelineadodb.recordset vbaworkbooks.saveconnection vbavba excel outlookhow to use vlookup step by stepvlookup functions in excelhow to use pivot in excel 2007stacked line chart excelinsert row excelsql ddl and dml commandsdim as worksheetexcel macro range variableexcel sql commandsexcel macro for dummiesexcel formula based on color of cellexcel subtract two datesvba sortingrecordset vba accessautomation testing interview questions and answers for freshersinsert a new worksheet in excelremove hyperlink excelword applicationsadd developer tab to ribbon in microsoft wordnested vlookup in excelmicrosoft excel offsetwhat is dml and ddl in sql servercells.find vbacreate a hyperlink in excelhow to insert macros in excelsas sql coursemacro basics excelhow to create a workbook in excelexcel macro to merge cellscoding macros in excelfiledialog filterpassword protect excel vbavba addressdata validation in excel 2010 tutorialadvanced vba excel examplesdelete blank cells in exceladvanced excel formulas with examplesvba selection.deleteproject management dashboard excel template free downloadexcel vba userform refreshexcel vba hide columnsswot analysis templates powerpointdelete duplicate datahow to unshare a workbookenable developer in excelvba codevba data validation listcheckboxes exceluse of sumifs in excelhow do you delete rows in excelexcel vba object modelexcel color index chartexcel protect sheetexcel 2007 timeline templatevba for excel 2007left function in vbahow to arrange numbers in excelmsg box vbavba excel workbookexcel vba savevba code functioncopy cells vbaexcel sendmailcolor in excel formulahow do i unhide column a in excel