Difference between revisions of "Manuals/calci/ROUNDDOWN"
Jump to navigation
Jump to search
| Line 79: | Line 79: | ||
| class="sshl_f" | 0 | | class="sshl_f" | 0 | ||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|_MIn3zFkEcc|280|center|ROUNDING DECIMALS}} | ||
== See Also == | == See Also == | ||
Revision as of 08:24, 29 April 2015
ROUNDDOWN(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.
ROUNDDOWN() rounds a number to specified number of digits towards zero.
Description
ROUNDDOWN(number, num_of_digits)
This function is used to round a number down towards zero, to the number of decimal digits specified in the argument.
For Example,
ROUNDDOWN(67.8,0) returns 67 as a result.
ROUNDDOWN(6.83112,3) returns 6.831 as a result.
- If 'num_of_digits' is omitted, Calci displays #NaN error message.
- The number is rounded down to the specified number of decimal places, if num_of_digits > 0.
- The number is rounded down to the nearest integer, if num_of_digits = 0.
- The number is rounded down to the left of the decimal point, if num_of_digits < 0.
- If any argument is non-numeric, Calci displays #NaN error message.
ROUNDDOWN() can also be used for multiple number array as -
ROUNDDOWN(2.55..7.55,1) that rounds the numbers 2.55 to 7.55 to one decimal place.
| Number | Num_of_digits | ROUNDDOWN |
|---|---|---|
| 2.55 | 1 | 2.5 |
| 3.55 | 1 | 3.5 |
| 4.55 | 1 | 4.5 |
| 5.55 | 1 | 5.5 |
| 6.55 | 1 | 6.5 |
| 7.55 | 1 | 7.5 |
- ROUND() can be used to round a number to specified number of digits.
- ROUNDUP() can be used to round a number away from zero.
- MROUND() can be used to round a number to desired multiple.