Documentation/Calc Functions/ODD

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

ODD

Category:

Mathematical

Summary:

Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.

Syntax:

ODD(Number)

Returns:

Returns Number rounded to the next odd integer up, away from zero.

Arguments:

Number is a real number or a reference to the cell containing that number whose even rounded up/down value is to be calculated.

Additional details:

None

Examples:

Formula Description Returns
=ODD(2.3) rounds up 2.3 to the nearest odd integer 3
=ODD(2) rounds up 2 to the nearest odd integer 3
=ODD(0) rounds up 0 to the nearest odd integer 1
=ODD(-0.5) rounds down -0.5 to the nearest odd integer -1
=ODD(-3.1) rounds down -5 to the nearest odd integer -5

Related LibreOffice functions:

EVEN

ODF standard:

Section 6.16.44, part2

Equivalent Excel functions:

ODD