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


system date in vbavba sample programscreate checkbox in excel 2010how to unlock a protected excel sheet without passwordvba lock cellsvba columns selectvlookup vba examplesales dashboard examplespaste in vbasql where operatorsexcel macro copy row to another sheetexcel shortcut chartprotect cells excel 2007do while loop excel vbatemplate for costing of a projectfso.fileexistsvba rs openhow to merge cells in excel 2013excel simple gantt chart templateexcel test for nulldml and ddlexcel macro if statementvba symbolbasic excel shortcutsvba columnwidthvba combobox codevba delete empty rowsexcel 2007 protect workbookhow do you sort columns in excelpivot table help excel 2010sample excel vba codesas analytics tutorialappend exceldynamic range excel vbaexcel remove blank linesnested if then statements in excelexcel 2007 macros tutorialvba sqrt functionwww vlookup formula excelactivesheet.namevba lastrowexcel macro formulasvlookup 2 conditionslistbox examplevba cleardynamic dashboard template in excelif vlookup is truehow to protect an excel sheetdelete duplicate exceldatabase interview questions and answers for freshersc programming interview questions and answers for freshers pdfcount columns excelexcel 2010 unhide worksheetvba selection.deletepivot chart excel 2010 tutorialexamples of spread sheetshow to do descending order in excelvbscript connect to sql serverrange properties vbahighlight column excelproforma of minutes of meetingpivot table dynamic rangeexcel combine data from multiple worksheetsmark duplicates in exceldefine merging cellsproject dashboard template powerpointexcel vba delete named rangeis not blank excelvba userform controlscompile data from multiple excel worksheetsdaily scrum meeting templateexcel macro creationunmerge excelcreate userformvba print pdfexcel forms comboboxvba macro loopuserform excel 2010how to remove duplicates in excel 2013how to unhide worksheetdeleting a pivot tableexcel formula worksheet name