Skip to content
Google Sheets

ODD function in Google Sheets

Rounds a number up to the nearest odd integer.

=ODD(value)

ODD syntax and parameters

One argument, one required.

  • valuenumberRequired

    The value to round to the next greatest odd number. If value is negative, it will be rounded down to the next negative odd number with greater absolute value.

ODD examples

Formulas you'll actually reuse.

  1. Away from zero to the next odd number — 6 becomes 7:

    =ODD(B2)

    Result7

  2. Negatives move away from zero too: −2.1 becomes −3:

    =ODD(-2.1)

    Result-3

ODD in Excel

Same name — your formula ports as-is.

Try ODD in the playground

Edit the example — nothing to install.

Preloaded with the ODD formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.