Information Functions

Illustration of definitions of four of Excel's information functions
  • ISBLANK Function Example 1
    View an example of MS Excel Spreadsheet’s Isblank Function testing whether a Middle Name is blank.
  • ISBLANK Function Example 2
    View an example demonstrating exactly what Excel’s ISBLANK Function tests for. Download your own copy of our companion workbook to explore.
  • ISERROR Function Example 1
    View an example of MS Excel Spreadsheet’s Iserror Function testing for an error from a search for a 2nd space in a Complete Name.
  • ISERROR Function Example 2
    View an example of Excel’s ISERROR Function, applied. Also, download your own copy of our companion workbook, and try the challenge:)
  • ISNUMBER Function Example 1
    View an example applying Excel’s ISNUMBER function. Download your own copy of our companion workbook to explore, and also try the challenge.
  • ISTEXT Function Example 1
    View an example using Excel’s ISTEXT function. Download your own copy of our companion workbook to explore.
  • Information Functions Challenges
    Try your hand at applying Excel’s Information Functions, ISBLANK and ISNUMBER, within a Nested IF function, to guide user spreadsheet input. Download the companion workbook with the link below.