IS Functions

Freebeginner 15 min4 tasks0/48 pts

The IS functions inspect a cell and return TRUE or FALSE: ISNUMBER, ISTEXT, ISBLANK and ISERROR. They never fail, so they are perfect for checking data before you calculate with it, usually inside IF.

Syntax

ISNUMBER(value) · ISTEXT(value) · ISBLANK(value) · ISERROR(value)

Example: =IF(ISBLANK(A2),"Missing",A2) shows "Missing" for empty cells.

Common mistakes

A cell with a space looks blank but ISBLANK says FALSE.
Numbers typed as text (like "42") make ISNUMBER FALSE.

AND, OR, XOR Functions IFS Function