Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN roundsall numbers down.
Whennum_digitsis greater than zero, the ROUNDDOWN function rounds on therightside of the decimal point.
Whennum_digitsis less or equal to zero, the ROUNDDOWN function rounds on theleftside of the decimal point.
Use zero (0) fornum_digitsto round to the nearest integer.
The steps look like this:
1.
The precision is determined by the number of decimal places provided as thenum_digitsargument.
Determine the rounding digit.
This is the number in the place you are rounding to.
Leave the rounding digit alone and treat the remaining digits to the right as zero.
For example, to round the number 2.786 to the nearest tenth (i.e.
Nesting calculations inside ROUNDDOWN
Other operations and functions can benestedinside ROUNDDOWN.
The ROUND function can round to the right or left of the decimal point.
CEILING works like theMROUND function, but CEILINGalways rounds up.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
MROUND Function
The Excel MROUND function returns a number rounded to a given multiple.
MROUND will round a number up or down, depending on the nearest multiple.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
