Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDUP roundsall numbers up.
Whennum_digitsis greater than zero, the ROUNDUP function rounds on therightside of the decimal point.
Whennum_digitsis less or equal to zero, the ROUNDUP 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 thenum_digitsargument, which sets the number of decimal places to be returned.
Determine the rounding digit.
This is the number in the place you are rounding to.
If any non-zero numbers follow the rounding digit, increment the rounding digit by 1.
For example, to round the number 2.123 to up the nearest tenth (i.e.
Nesting calculations inside ROUNDUP
Other operations and functions can benestedinside the ROUNDUP function.
The ROUND function can round to the right or left of the decimal point.
ROUNDDOWN Function
The Excel ROUNDDOWN function returns a number rounded down to a given number of places.
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.
