Please note javascript is required for full website functionality.


A to Z of Excel Functions: the ODD Function

24 April 2023

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the ODD function.


The ODD function

It might seem odd, but this function returns a number rounded up to the nearest ODD integer. You can use this function for ensuring a binary number always ends in one [1].

The ODD function employs the following syntax to operate:


The ODD function has the following arguments:

  • number: this is required and represents the value to round.

It should be further noted that:

  • if number is nonnumeric, ODD returns the #VALUE! error value
  • regardless of the sign of number (i.e. positive, zero or negative), a value is rounded up when adjusted away from zero.  If number is an ODD integer, no rounding occurs.

Please see my example below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here