Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - What are the formulas for Excel to take integers?
What are the formulas for Excel to take integers?
In the process of excel tabulation, there are many functional formulas that can greatly improve our tabulation efficiency. As long as these functional formulas are used reasonably, we can improve our work efficiency and quality. I summed it up for you today? Excel formula for integer? There are 7 kinds of daquan, so you can take notes for reference and use.

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.