Spread 8.0 Documentation
ODD
Support Options
Formula Reference > Built-In Functions > ODD

Glossary Item Box

ODD


Name

Odd integer

Description

Rounds the specified value up to the nearest odd integer.

Syntax

ODD(value)

Remarks

Regardless of the sign of the number specified by the value argument, the number is rounded away from zero.

See also CEILING, EVEN, FLOOR, INT, ROUND, ROUNDDOWN, ROUNDUP, and TRUNC.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

ODD(R1C2)
ODD(A3)
ODD(4)=5
ODD(-2.5)=-3

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.