ISBLANK

Purpose

Checks whether a cell is empty.

Syntax

=ISBLANK(value)

Example

Cell	Value
A2	Amit
A3	125
A4	(empty)

Formula:

=ISBLANK(A4)

Result:

TRUE

Formula:

=ISBLANK(A2)

Result:

FALSE

ISNUMBER

Checks whether a value is numeric.

=ISNUMBER(A3)

Result:

TRUE

ISTEXT

Checks whether a value is text.

=ISTEXT(A2)

Result:

TRUE

Practical Example

Data	Type
Amit
125
45.5
Sirsa
(blank)

Use:

=IF(ISNUMBER(A2),”Number”,”Not Number”)

and:

=IF(ISTEXT(A2),”Text”,”Not Text”)

Practice

Create a Data Type Checker that identifies whether each cell contains text, a number, or is blank.