Information Functions
Master 17 Excel information functions like ISNUMBER, ISTEXT, ISBLANK, ISERROR, and TYPE with interactive exercises. Inspect cells and validate data types efficiently.
Live Score Feedback
Active Logic Validation
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 expertise path is engineered for maximum logic retention. We use interactive simulations to ensure every advanced function is immediately applied to real-world datasets."