ODD
What Does It Do?
This function rounds a number up to the next highest whole odd number.
Syntax
=ODD(NumberToBeRounded)
Formatting
No special formatting is needed.
| Number | Rounded To Next Odd | |
| 2 | 3 | =ODD(C4) |
| 2.4 | 3 | =ODD(C5) |
| 2.9 | 3 | =ODD(C6) |
| 3 | 3 | =ODD(C7) |
| 3.4 | 5 | =ODD(C8) |
| 3.9 | 5 | =ODD(C9) |