For example: Enter = ROUNDDOWN (12.78,0) in any cell in Excel, the result will be 12.
Function syntax: = CEILING (number, significance) .
Inside:
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.
Function syntax: = FLOOR (number, significance) .
Inside:
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.
Function syntax: = INT (number) .
Inside:
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!