writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Manuals/calci/ROUNDUP (view source)
Revision as of 21:58, 27 November 2013
, 21:58, 27 November 2013no edit summary
=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 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.
ROUNDUP() can also be used for multiple number array as -
ROUNDUP(2.5..6..0.5) that rounds the numbers from 2.5 to 6 in steps of 0.5.
{| class="wikitable"
|-
! Number !! ROUNDUP
|-
| 2.5 || 3
|-
| 3 || 3
|-
| 3.5 || 4
|-
| 4 || 4
|-
| 4.5 || 5
|-
| 5 || 5
|-
| 5.5 || 6
|-
| 6 || 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.
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">