This function rounds a positive number up, and a negative number down, to the nearest odd integer.
Odd([Number])
Where:
Number is a number or a reference to a number to be rounded.
If the number is positive, the Odd function, when calculated, will return the specified number, rounded up to the nearest odd integer
If the number is negative, the Odd function, when calculated, will return the specified number, rounded down to the nearest odd integer
Rule | Meaning |
|---|---|
| Odd(CustomerNumberTextBoxReturn) | Depending on if the return value from the CustomerNumberTextBox is positive or negative, the Odd function will return the value of the CustomerNumberTextBoxReturn, rounded up or down, to the nearest odd integer. |
CustomerNumberTextBoxReturn Value | Result of the Odd function |
|---|---|
| 12 | 13 |
| -12 | -13 |
| 17.2 | 19 |
| 14.32 | 15 |
| -9.42 | -11 |