Whennum_digitsis greater than zero, the ROUND function rounds on therightside of the decimal point.
Whennum_digitsis less or equal to zero, the ROUND function rounds on theleftside of the decimal point.
Use zero (0) fornum_digitsto round to the nearest integer.
The result is less accurate, but easier to use.
The ROUND function uses a standard rounding process 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.
Round the number based on thenext number to the right.
Leave the rounding digit the same if the next number to the right is less than 5.
Increase the rounding digit by 1 if the next number is 5 or more.
In contrast, the ROUND function will round a number and return amodified numberas a final result.
For details on Excel’s custom number formatting with many examples,see this article.
MROUND will round a number up or down, depending on the nearest multiple.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
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.
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.
