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


vba selectexcel vba if statement multiple conditionsconcatenate using vbaactive worksheet vbaexcel 2007 countifssub function vbaexcel vba forms advancedautomatic hyperlink excelvba excel outlookinsert a checkbox in excelexcel formulas offsetplsql for dummiesproject management templates excelpivot table refresh allhow to display developer tab in excel 2010protect excel worksheetvba tutorwhat is excel ribbonoutlook application vbahow can i find duplicates in exceltimeline templates for excelvba dir functionvba range commandinsert hyperlink excellistbox item selectedconvert excel csvexcel vba removesort ascending excelddl dml and dclvba elseifselect column excel vbavba loop through range by rowgenpact aptitude questionscreate a check box in excelunhide all tabs in excelchecklist excel templatematch formula in excel with exampleexcel advanced vbawindows activate vbaschedule excel macrocreate a new worksheet in excelexcel macro to remove duplicatescheck box vbawhat are the shortcut keys in ms exceladodb connection objectexcel macros not workingcountif function on excelexcel vba rowshow to remove duplicate items in excelhow to remove duplicates from two columns in excelexcel vba rangeshow to multiple columns in excelexcel vba objectsproject tracker template excelhow to insert check mark in excel 2007testing fresher interview questionsjob costing excel templateexcel remove duplicates from columnhow to insert column in exceldashboards for excelvba usedrangecount rows vbaexcel hyperlink buttoncharting with excelhow do you merge columns in excelmeeting template excelcreating macro in excel 2007excel vba 2d arrayvb interview questions and answers pdfvbscript excelcolumn width excel vbahow do i check for duplicates in excelvba deletecode execution has been interrupted excel vbaexcel range macroexcel vba onclickaccess sql vbams access run query vbaexcel vba arrays