• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendixes > Information Functions

Information Functions

Information functions typically answer questions about portions of your worksheet. For example, you can use an information function to find out if a specific cell is blank, what formatting is applied to it, its data type, or other types of information. Table B.4 covers the information functions in Excel.

Table B.4. Information Functions in Excel
Function SyntaxReturns
=CELL(info_type,reference)Information on the formatting, location, or contents of a cell
=ERROR.TYPE(error_val)Number that corresponds to an error value
=INFO(type_text)Information about the current operating environment
=ISBLANK(value)TRUE if value is a blank reference; otherwise, FALSE
=ISERR(value)TRUE if value is any error (except #N/A); otherwise, FALSE
=ISERROR(value)TRUE if value is any error value; otherwise, FALSE
=ISEVEN(value)TRUE if value is even; otherwise FALSE
=ISLOGICAL(value)TRUE if value is a logical value; otherwise, FALSE
=ISNA(value)TRUE if value is the #N/Aerror value; otherwise, FALSE
=ISNONTEXT(value)TRUE if value is not text; otherwise, FALSE
=ISNUMBER(value)TRUE if value is a number; otherwise, FALSE
=ISODD(value)TRUE if value is odd; otherwise FALSE
=ISREF(value)TRUE if value is a reference; otherwise, FALSE
=ISTEXT(value)TRUE if value is text; otherwise, FALSE
=N(value)Number converted from a value using certain rules
=NA( )Error value #N/A(value not available)
=TYPE(value)Number indicating data type of a value



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint