The ODD function rounds a number away from zero to the next odd number.
ODD(num-to-round)
num-to-round: The number value to be rounded.
Examples |
|---|
=ODD(1) returns 1, because 1 is an odd number. =ODD(2) returns 3, the nearest odd number going away from zero. =ODD(2.5) returns 3, the nearest odd number going away from zero. =ODD(-2.5) returns -3, the nearest odd number going away from zero. =ODD(0) returns 1, the nearest odd number going away from zero. |