Information Functions
Master 17 Excel information functions like ISNUMBER, ISTEXT, ISBLANK, ISERROR, and TYPE with interactive exercises. Inspect cells and validate data types efficiently.
Instant Feedback
Live Answer Checking
Industry Datasets
Information Functions Foundations
Learn how Excel information functions check data types, detect errors, and help you build safer formulas.
Isbinary Function
Return TRUE when a value is a valid binary string made only of 0s and 1s.
Isblank Function
Return TRUE only when a cell is truly empty.
Iserr Function
Return TRUE for Excel errors except #N/A.
Iserror Function
Return TRUE when a value contains any Excel error.
Iseven Function
Return TRUE when a number is even.
Isformula Function
Return TRUE when a referenced cell contains a formula.
Islogical Function
Return TRUE only for the logical values TRUE and FALSE.
Isna Function
Return TRUE only when a value is the #N/A error.
Isnontext Function
Return TRUE when a value is anything except text.
Isnumber Function
Return TRUE when a value is numeric.
Isodd Function
Return TRUE when a number is odd.
Isref Function
Return TRUE when a value is a valid reference.
Istext Function
Return TRUE when a value is text.
Na Function
Return the #N/A error on purpose when a value should be marked as not available.
Sheet Function
Return the index number of a sheet.
Sheets Function
Return the number of sheets in a workbook or reference.
Type Function
Return a numeric code that tells you the data type of a value.
"This path helps you learn by doing. Each lesson teaches a new function with hands-on practice and real-world examples so the skills stick."