Rounding formula 1: integer rounding.
For positive numbers, round off decimals.
=INT( 12.6) The result is 12.
For negative numbers, the decimal number is truncated and then rounded to-1.
=INT(- 12.6) The result is-13.
Rounding Formula 2: TRUNC Rounding
For both positive and negative numbers, it is truncated and rounded.
=TRUNC( 12.6) The result is 12.
=TRUNC(- 12.6) The result is-12.
Rounding Formula 3: Rounding
When the second parameter of the ROUND function is 0, rounding can be completed.
=ROUND( 12.4) The result is 12.
=ROUND( 12.6) The result is 13.
Rounding Formula 4: Integer Rounding
When the second parameter of the ROUND function is negative, the rounding of integer bits can be completed.
=ROUND( 1534.56,-1) The result is 1530.
=ROUND( 1534.56, -2) The result is 1500.
=ROUND( 1534.56, -3) The result is 2000.
Rounding Formula 5: Rounding up.
As long as the value is greater than 1, it can be moved up one place. This function can be realized by the ROUNDUP function.
=ROUNDUP( 12. 1, 0) is verified as 13.
= roundup (12.6,0) The result is 13.
= roundup (12. 1,-1) the result is 20.
Rounding Formula 6: Multiple rounds.
The upper bound function can achieve multiple rounds up, that is, specify multiple rounds up.
= ceiling (3,5) The result is 5 (0 times of 65438+5).
= ceiling (8,5) The result is 10 (twice as much as 5).
= ceiling (8,3) The result is 9 (3 times that of 3).
Rounding Formula 7: Multiple rounding rounds down.
The FLOOR function can achieve multiple rounds down, that is, multiple rounds down the specified value.
= floor (3,5) The result is 0 (0 times of 5).
= floor (8,5) The result is 5 (twice as much as 5).
= floor (8,3) The result is 6 (twice as much as 3).
The above is the formula I summarized for you in excel. I hope it will help you.