[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
ODD ( x )
Description: Computes x rounded to the nearest odd integer, away from zero. Regardless of the sign of x, a value is rounded up when adjusted away from zero.
Arguments:
|
Name |
Type |
Description |
|
number |
The value to be rounded. |
Return Type and Value: number – The rounded value of x.
[Example:
ODD(1.5) rounds 1.5 up to the nearest odd integer; that is, to 3
ODD(3) rounds 3 up to the nearest odd integer; that is, to 3
ODD(2) rounds 2 up to the nearest odd integer; that is, to 3
ODD(-1) rounds -1 up to the nearest odd integer; that is, to -1
ODD(-2) rounds -2 up to the nearest odd integer; that is, to -3
end example]