A to Z of Excel Functions: The ODD Function

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.