How to round whole numbers in Excel

How to round whole numbers in Excel In Excel there are many mathematical functions used to round numbers. Today Software tips will guide you some functions that can be used to round whole numbers in Excel.

In Excel there are many mathematical functions used to round numbers. Today Software tips will guide you some functions that can be used to round whole numbers in Excel.

How to round whole numbers in Excel Picture 1How to round whole numbers in Excel Picture 1

Round an integer with the ROUND function

Function syntax: = ROUND (number, num_digits) .

Inside:

  1. Number: is the number to be rounded.
  2. Num_Digits: is the number of words to be rounded. To round up to the whole part, choose num_digits equal to 0.

For example: Enter = ROUND (12.3445678,0) in any cell in Excel, the result will be 12.

Round an integer with the ROUNDUP function

Function syntax: = ROUNDUP (number, num_digits) .

Inside:

  1. Number: is the number to be rounded.
  2. Num_Digits: is the number of words to be rounded. To round up to the whole part, choose num_digits equal to 0.

The ROUNDUP function will return a value greater than the original number.

For example: Enter = ROUNDUP (12.3445678,0) in any cell in Excel, the result will be 13.

Round an integer with the ROUNDDOWN function

Function syntax: = ROUNDDOWN (number, num_digits) .

Inside:

  1. Number: is the number to be rounded.
  2. Num_Digits: is the number of words to be rounded. To round up to the whole part, choose num_digits equal to 0.

The ROUNDDOWN function will return a value smaller than the original.
For example: Enter = ROUNDDOWN (12.78,0) in any cell in Excel, the result will be 12.

Round an integer with the CEILING function

Function syntax: = CEILING (number, significance) .

Inside:

  1. Number: is the value you want to round.
  2. S ignificance: is the multiple that you want to be rounded to.

The CEILING function is a function that rounds up far away from 0, to the nearest multiple. So if you want to round whole numbers in Excel, choose the Significance multiple of 1. 

For example: You enter the formula = CEILING (12.3445678,1) into a cell in an Excel spreadsheet and the result is 13.

Rounds whole numbers with the FLOOR function

Function syntax: = FLOOR (number, significance) .

Inside:

  1. Number: is the value you want to round.
  2. S ignificance: is the multiple that you want to be rounded to.

The FLOOR function is a function that rounds to 0, to the nearest multiple. So if you want to round whole numbers in Excel, choose the Significance multiple of 1. 

For example: You enter the formula = FLOOR (12.3445678,1) into a cell in an Excel spreadsheet and the result is 12.

The function takes an integer value INT

Function syntax: = INT (number) .

Inside:

  1. Number : is the number to take integer part.

The INT function returns the integer part of that number without rounding.

For example: You type the formula = INT (12.3445678) into any cell in an Excel spreadsheet, the result will be 12.

Note: According to math, the integer of a is the largest integer that does not exceed a. That is, if the number a is negative, then the integer will be the part before the comma plus 1 and keep the value negative. If you enter = INT (-12.3445678), the result will be -13. Because mathematically, -13 is the integer part of -12.3445678.

Above, the Software Tips showed you some integer round functions in Excel. Good luck!

5 ★ | 1 Vote