Difference between revisions of "Manuals/calci/ROUNDUP"
Jump to navigation
Jump to search
| Line 49: | Line 49: | ||
*ROUNDDOWN() can be used to round a number towards zero. | *ROUNDDOWN() can be used to round a number towards zero. | ||
*MROUND() can be used to round a number to desired multiple. | *MROUND() can be used to round a number to desired multiple. | ||
| + | |||
| + | == Examples == | ||
| + | |||
| + | <div id="6SpaceContent" class="zcontent" align="left"> | ||
| + | |||
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
| + | |- class="even" | ||
| + | | class=" " | '''Function''' | ||
| + | | class=" " | '''Output''' | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" | ROUND(3.6712,2) | ||
| + | | class="sshl_f" | 3.67 | ||
| + | |||
| + | |- class="even" | ||
| + | | class="sshl_f" | ROUND(99.37,0) | ||
| + | | class="sshl_f" | 99 | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" | ROUND(99.37) | ||
| + | | class="sshl_f" | 99 | ||
| + | |||
| + | |- class="even" | ||
| + | | class="sshl_f" | ROUND(145.8,-1) | ||
| + | | class="sshl_f" | 150 | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" | ROUND(-89.65,1) | ||
| + | | class="sshl_f" | -89.7 | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" | ROUND(-89.65,-1) | ||
| + | | class="sshl_f" | -90 | ||
| + | |} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN]] | ||
| + | |||
| + | *[[Manuals/calci/ROUND | ROUND]] | ||
| + | |||
| + | *[[Manuals/calci/MROUND | MROUND]] | ||
| + | |||
| + | *[[Manuals/calci/INT | INT]] | ||
| + | |||
| + | *[[Manuals/calci/TRUNC | TRUNC]] | ||
| + | |||
| + | *[[Manuals/calci/CEILING | CEILING]] | ||
| + | |||
| + | *[[Manuals/calci/FLOOR | FLOOR]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Rounding Round Function] | ||
Revision as of 17:25, 27 November 2013
ROUNDUP(number, num_of_digits)
- Where 'number' is the number to round and
- 'num_of_digits' is the number of digits to which the number is to be rounded.
ROUNDUP() rounds a number to specified number of digits away from 0.
Description
ROUNDUP(number, num_of_digits)
This function is used to round a number up away from zero, to specified number of decimal digits mentioned in the argument.
For Example,
ROUNDUP(67.8,0) returns 68 as a result.
ROUNDUP(6.83112,3) returns 6.832 as a result.
- If 'num_of_digits' is omitted, Calci displays #NaN error message.
- The number is rounded up to the specified number of decimal places, if num_of_digits > 0.
- The number is rounded up to the nearest integer, if num_of_digits = 0.
- The number is rounded up to the left of the decimal point, if num_of_digits < 0.
- If any argument is non-numeric, Calci displays #NaN error message.
ROUNDUP() can also be used for multiple number array as -
ROUNDUP(2.55..7.55,1) that rounds the numbers 2.55 to 6.55 to one decimal place.
| Number | Num_of_digits | ROUNDUP |
|---|---|---|
| 2.55 | 1 | 2.6 |
| 3.55 | 1 | 3.6 |
| 4.55 | 1 | 4.6 |
| 5.55 | 1 | 5.6 |
| 6.55 | 1 | 6.6 |
| 7.55 | 1 | 7.6 |
- ROUND() can be used to round a number to specified number of digits.
- ROUNDDOWN() can be used to round a number towards zero.
- MROUND() can be used to round a number to desired multiple.