[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ISODD

Syntax:

ISODD ( value )

Description: Determines if value is an odd number or refers to a cell containing an odd 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 odd number or refers to a cell containing an odd number; otherwise, FALSE.

[Example:

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

end example]