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


what is the purpose of macros in excelnested vlookup functionnotepad vbavba experiencecheck excel for duplicatesaccess vba sql queryinsert a macro in exceltechnical interview questions and answers for freshersexcel vba tableloop through worksheets vbaworksheet and workbookvba range sortcolumns vbavba startauto fit row heightms access vba update queryvlookup hlookup combinationmacro excel enableexcel vba adodb connectionproject checklist template wordsql interview questions and answers for freshers pdf downloadleft excel vbaexcel event calendar templateexcel 2007 index functionvba procedureexcel formula codesexcel dashboards tutorialactivex comboboxdynamic array vbamultiple if and statements in excelremove duplicate vbaexcel vba cell widthremove duplicates in arraywhy we use vlookup function in excelexcel macro operatorsdcl data control languageaverageif in excelhow to use vlookup 2010excel vba fill colorvba selection.deletehow to unhide column a in excel 2013excel vba refresh pivot tableexcel 2007 lookup functionexcel vba save as xlsxvba screenupdatingconsolidate function excelhow to create a userform in excel 2010how to unlock an excel spreadsheet for editingexcel template for project trackingvba select cellarrays vba excelexcel delete cellusing worksheet functions in vbahlookup function excelfso vbavba reference guideexcel workbook passwordvba textboxvba macro codevba scripting in excelhow to protect specific cells in excel 2007cell format vbaddl languagefind last row vbams access ddlhow to unhide rows in excel 2013cost estimate excel templateexcel vba cut and paste rangeoffset function in vbaexcel formulas shortcut keys 2007vlookup using vbaexcel combo box multiple selectionshow to delete lines in excelexcel lookup and reference functionsexcel macros not workingwhere to find pivot table in excelexcel vba paste specialvba code tutorialvba trim spaces