Manuals/calci/ROUNDDOWN
Jump to navigation
Jump to search
Syntax
Remarks
Examples
''''''' ''''
Description
ROUNDDOWN
ROUNDDOWN (n, ndigit)
Where n is a number that you want rounded down and ndigit is the number of digits to which want to round the number.
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 6.8 | 6.83112 | 2245888.56 | |||
| Row2 | 0 | 3 | -4 | |||
| Row3 | 6 | 6.831 | 2240000 | |||
| Row4 | ||||||
| Row6 |
· n is rounded down to the specified number of decimal places if ndigit is greater than 0.
· n is rounded down to the nearest integer if ndigit is 0.
· n is rounded down to the left of the decimal point if ndigit is less than 0.
ROUNDDOWN functions rounds a number down, towards zero.
1. If n = 6.8 and ndigit =0, then
=ROUNDDOWN(6.8,0) gives you 6
2. If n = 6.83112 and ndigit =3, then
=ROUNDDOWN(6.83112,3) gives you 6.831
3. If n = 2245888.56 and ndigit = -4, then
=ROUNDDOWN(2245888.56,-4) gives you 2240000