1. Home
  2. Functions
  3. Math
  4. ODD

ODD function

Rounds a number away from zero to the nearest odd integer.

Syntax

=ODD(number)

Arguments

ArgumentRequiredDescription
numberRequiredThe number

How to use ODD

ODD takes 1 required argument. Type =ODD( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.

Examples

Each result below was calculated by the SheetsBat formula engine.

=ODD(1.5)Result 3
=ODD(2)Result 3
=ODD(-1)Result -1

Every formula, right in your browser

SheetsBat calculates 536 functions, with charts, pivot tables and live collaboration. Free to start.