ROUND
A number rounded to the nearest whole number.
Syntax
ROUND(x)
| Argument | Meaning |
|---|---|
| x | A number. |
Result
A whole number.
Examples
In the example drawing:
| Expression | Gives |
|---|---|
ROUND(2.5) |
2 |
ROUND(3.5) |
4 |
ROUND(2.4) |
2 |
ROUND(7/2) |
4 |
ROUND(1'6 3/4") |
1'7" |
Notes
A number exactly half way rounds to the even one: 2.5 to 2, 3.5 to 4. A fraction gives a whole number exactly, and feet and inches are rounded to whole inches.