[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ISEVEN ( value )
Description: Determines if value is an even number or refers to a cell containing an even number.
Arguments:
|
Name |
Type |
Description |
|
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]