Nearest Odd Integer (ODD)

Syntax: ODD(Number)

This is the function to use if you want results to be rounded up to the nearest odd integer. For example:

=ODD(12.3)

returns 13.

images

Figure 6-5. Sample result of the ODD function

See also the sections on the CEILING, EVEN, INT, FLOOR, ROUND, ROUNDDOWN, and ROUNDUP functions.

Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.