ODD(number)

Returns the number rounded up to the nearest odd integer.

numberThe number you want to round down.

Remarks

* 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.office.com

 A
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!


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