ℹ️ Information Functions

Inspect your data. Check for errors, blanks, numbers, or text types to build robust error-handling logic.

01. ISNUMBER / ISTEXT

Check if a cell contains a valid number or text string. Essential for conditional formatting rules.

Identify truly empty cells versus those containing invisible spaces or zero-length strings.

⚠️ Handling

03. ISERROR / ISNA

Catch errors like #N/A, #VALUE!, or #DIV/0! before they break your downstream formulas.

🏷️ Metadata

04. TYPE / CELL

Get technical details about cell formatting, column width, or specific content types (Number vs Text).

🔢 Diagnostics

Returns a specific number representing the error type (e.g., 2 for #DIV/0!, 7 for #N/A).

⬅ Back to Excel Menu