[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ISEVEN

Syntax:

ISEVEN ( value )

Description: Determines if value is an even number or refers to a cell containing an even number.

Arguments:

Name

Type

Description

value

number

The value to be tested. It is truncated to an integer.

 

Return Type and Value: logical – TRUE if value is an even number or refers to a cell containing an even number; otherwise, FALSE.

[Example:

ISEVEN(12.456) results in TRUE
ISEVEN(A10) results in FALSE, when A10 contains -15

end example]