The Excel ODD function returns
the next odd integer after rounding a given number up. The ODD function always
rounds numbers up (away from zero) so positive numbers become larger
and negative numbers become smaller (i.e. more negative).
Syntax
The syntax for the ODD
function in Microsoft Excel is:
=ODD( number )
Parameters or Arguments
number
A numeric value that will be
rounded up to the nearest odd integer.
Odd Function Examples
The following spreadsheet
shows several examples of the Excel Odd function:
Formulas:
|
|
A
|
B
|
|
1
|
|
=ODD( 22
)
|
|
2
|
1.22
|
=ODD( A2
)
|
|
3
|
|
=ODD(
A2+4 )
|
|
4
|
0
|
=ODD( A4
)
|
|
5
|
-1.3
|
=ODD( A5
)
|
|
6
|
-10
|
=ODD( A6
)
|
|
7
|
-3
|
=ODD( A7
)
|
Results:
|
|
A
|
B
|
|
1
|
|
23
|
|
2
|
1.22
|
3
|
|
3
|
|
7
|
|
4
|
0
|
1
|
|
5
|
-1.3
|
-3
|
|
6
|
-10
|
-11
|
|
7
|
-3
|
-3
|
The above examples show how
the odd function always rounds away from zero. I.e. If the supplied number is
positive, it is rounded up (more positive), but if the supplied number is
negative, it is rounded down (more negative).
If the number argument is exactly
equal to zero, as shown in cell B4 of the example spreadsheet above, the Excel
Odd function rounds to the positive value +1.
References
No comments:
Post a Comment