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 .
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.