ROUND
ROUND rounds a given number to the nearest integer. Rounding can be done in a variety of ways.
This function is valid in both rules and TurboIntegrator processes.
The most basic form of rounding is to replace an arbitrary number by an integer. There are many ways of rounding a number y to an integer q.
The most common ones are:
- Round to nearest
q is the integer that is closest to y (see "Round away from zero" for tie-breaking rules).
- Round towards zero (or truncate)
q is the integer part of y, without its fraction digits.
- Round down (or take the floor)
q is the largest integer that does not exceed y.
- Round up (or take the ceiling)
q is the smallest integer that is not less than y.
- Round away from zero
If y is an integer, q is y; else q is the integer that is closest to 0 and is such that y is between 0 and q.
TurboIntegrator essentially uses the Round down method of floor(x + .5). Microsoft Excel uses the Round to nearest method. This can result in different integers depending on whether you are using a TurboIntegrator process or working in Excel.
Syntax
ROUND(number)|
Argument |
Description |
|---|---|
|
number |
The number you want to round. |
Example
ROUND(1.46) returns 1.