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