Difference between revisions of "Manuals/calci/ROUNDUP"
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| + | =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"> | ||
Revision as of 15:58, 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 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.
| 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.
Syntax
Remarks
Examples
Description
ROUNDUP (n, digit)
n is a number that you want rounded down.
ndigit is the number of digits to which you want to round number.
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 67.8 | 6.83112 | 2245888.56 | |||
| Row2 | 0 | 3 | -4 | |||
| Row3 | 68 | 6.832 | 2250000 | |||
| Row4 | ||||||
| Row6 |
· n is rounded up to the specified number of decimal places if ndigit is greater than 0.
· n is rounded up to the nearest integer if ndigit is 0.
· n is rounded up to the left of the decimal point if ndigit is less than 0.
ROUNDUP functions rounds a number up, away from 0.
1. If n = 67.8 and ndigit =0, then
=ROUNDUP(67.8,0) gives you 68
2. If n = 6.83112 and ndigit =3, then
=ROUNDUP(6.83112,3) gives you 6.832
3. If n = 2245888.56 and ndigit = -4, then
=ROUNDUP(2245888.56,-4) gives you 2250000