[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ISBLANK

Syntax:

ISBLANK ( value )

Description: Determines if value refers to an empty cell.

Arguments:

Name

Type

Description

value

any

The value to be tested. No conversion shall take place on an argument passed to this function.

 

Return Type and Value: logical – TRUE if value refers to an empty cell; otherwise, FALSE.

[Example:

ISBLANK(A10) results in TRUE, when A10 is empty
ISBLANK(A10) results in FALSE, when A10 contains 123

end example]