Returns the number rounded up to the nearest odd integer.

numberThe number you want to round down.


* If "number" is not numeric, then #VALUE! is returned.
* If "number" < 0, then the number is rounded down.
* If "number" is an odd number, then no rounding takes place.
* You can use the ROUND function to round to a specified number of digits.
* You can use the EVEN function to round up to the nearest even number.
* For the Microsoft documentation refer to support.microsoft.com

1=ODD(13) = 13
2=ODD(-8) = -9
3=ODD(20) = 21
4=ODD(0) = 1
5=ODD(-1) = -1
6=ODD("some text") = #VALUE!

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top