Difference between revisions of "Manuals/calci/ROUND"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | ! Number !! ROUND | + | ! Number !! ROUND |
|- | |- | ||
| 2.5 || 3 | | 2.5 || 3 | ||
| Line 60: | Line 60: | ||
| | | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | 3.6712 | + | | class="sshl_f" | ROUND(3.6712,2) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 3.67 |
| | | | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | ROUND(99.37,0) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 99 |
| | | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | ROUND(99.37) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 99 |
| | | | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | ROUND(145.8,-1) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 150 |
| | | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | ROUND(-89.65,1) |
| − | | class="sshl_f" | | + | | class="sshl_f" | -89.7 |
| | | | ||
|} | |} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/MROUND | MROUND]] | ||
| + | |||
| + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | ||
| + | |||
| + | *[[Manuals/calci/ROUNDUP | ROUNDUP]] | ||
| + | |||
| + | *[[Manuals/calci/INT | INT]] | ||
| + | |||
| + | *[[Manuals/calci/TRUNC | TRUNC]] | ||
| + | |||
| + | *[[Manuals/calci/CEILING | CEILING]] | ||
| + | |||
| + | *[[Manuals/calci/FLOOR | FLOOR]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Truncation TRUNC Function] | ||
Revision as of 12:53, 27 November 2013
ROUND(number, num_of_digits)
- Where 'number' is the number to round and
- 'num_of_digits' is the number of digits before or after decimal point.
ROUND() rounds a number to specified number of digits.
Description
ROUND(number, num_of_digits)
This function is used to round a number to certain number of digits mentioned in the argument.
For Example,
ROUND(3.6712,2) returns 3.67 as a result.
ROUND(411.3,-1) returns 410 as a result.
- If 'num_of_digits' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
- The number is rounded to the specified number of decimal places, if num_of_digits > 0.
- The number is rounded to the nearest integer, if num_of_digits = 0.
- The number is rounded to the left of the decimal point, if num_of_digits < 0.
- If any argument is non-numeric, Calci displays #NaN error message.
ROUND() can also be used for multiple number array as -
ROUND(2.5..6..0.5) that rounds the numbers from 2.5 to 6 in steps of 0.5.
| Number | ROUND |
|---|---|
| 2.5 | 3 |
| 3 | 3 |
| 3.5 | 4 |
| 4 | 4 |
| 4.5 | 5 |
| 5 | 5 |
| 5.5 | 6 |
| 6 | 6 |