Round Down to the Nearest Integer in Excel
Rounding numbers in Excel can be accomplished using a number of different functions depending on the results you want.
For example, the INT function can be used to round a number down to the next lowest integer while removing the decimal portion of a number.
Using this function can, therefore, affect the results of calculations.
The INT Function's Syntax and Arguments
The syntax for the INT function is:
= INT ( Number)
INT Function Example: Round Down to the Nearest Integer
For help with this example, see the image above.
In this example we will use the INT function to round a number down to the next lowest integer.
To show the effect rounding numbers has on calculations, both the original number and the rounded one will be multiplied by 10 and the results compared.
Entering the DataEnter the following data into the designated cells.
Cell Data D1 - 27.357 E1 - 10 E2 - 10
Entering the INT Function
- Click on cell D2 to make it the active cell - this is where the results of the INT function will be displayed.
- Click on the Formulas tab of the ribbon menu.
- Choose Math & Trig from the ribbon to open the function drop down list.
- Click on INT in the list to bring up the function's dialog box.
- In the dialog box, click on the Number line.
- Click on cell D1 in the worksheet to enter that cell reference into the dialog box.
- Click OK.
- The answer 27 should appear in cell D2.
- When you click on cell D2 the complete function = INT ( D1 ) appears in the formula bar above the worksheet.
Using the Modified Number in Calculations
- Click on cell F1 to make it the active cell - this is where the multiplication formula will be entered.
- Type an equal sign to begin the formula.
- Click on cell D1 to enter that cell reference into the formula.
- Type an asterisk ( * ) - the symbol for multiplication in Excel.
- Click on cell E1 to enter that cell reference into the formula.
- Press the Enter key on the keyboard to complete the formula.
- The answer 273.57 should appear in cell F1.
- Click on cell F1 again to make it the active cell.
- Copy the formula in F1 to cell F2 using the Fill Handle or Copy and Paste.
- The answer 270 should appear in cell F2.
The different formula results in cells F1 and F2 - 273.57 vs. 270 show the effect that removing decimal places can have on calculations.