On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Thursday, May 22, 2014

ODD Function in MS-Excel

C
D
3
Number
Rounded To
Next Odd
4
2
3
 =ODD(C4)
5
2.4
3
 =ODD(C5)
6
2.9
3
 =ODD(C6)
7
3
3
 =ODD(C7)
8
3.4
5
 =ODD(C8)
9
3.9
5
 =ODD(C9)

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.

Popular Posts