ISBLANK

Returns TRUE  if all the referenced cells are empty.

Syntax

ISBLANK(expression,{expression},...)

Arguments

expression

Values or cell references to examine.

Example

ISBLANK(A2..B5,D2..E5) returns FALSE if any cells contain data.