1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

INT Function: Round Down to the Nearest Integer in Excel

By

Excel's INT Function
Excel INT (Integer) Function

Excel INT (Integer) Function

© Ted French

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.

Unlike formatting options that allow you change the number of decimal places displayed by your data, the INT function actual alters the data in your worksheet.

Using this function can, therefore, affect the results of calculations.

The INT Function's Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the INT function is:

= INT ( Number)

Number - the value to be rounded down. This argument can contain the actual data for rounding or it can be a cell reference to the location of the data in the worksheet.

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 Data

Enter the following data into the designated cells.
 
Cell    Data 
 D1  -  27.357
 E1  -  10
 E2  -  10
 

Entering the INT Function

  1. Click on cell D2 to make it the active cell - this is where the results of the INT function will be displayed.

  2. Click on the Formulas tab of the ribbon menu.

  3. Choose Math & Trig from the ribbon to open the function drop down list.

  4. Click on INT in the list to bring up the function's dialog box.

  5. In the dialog box, click on the Number line.

  6. Click on cell D1 in the worksheet to enter that cell reference into the dialog box.

  7. Click OK.

  8. The answer 27 should appear in cell D2.

  9. 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

  1. Click on cell F1 to make it the active cell - this is where the multiplication formula will be entered.

  2. Type an equal sign to begin the formula.

  3. Click on cell D1 to enter that cell reference into the formula.

  4. Type an asterisk ( * ) - the symbol for multiplication in Excel.

  5. Click on cell E1 to enter that cell reference into the formula.

  6. Press the Enter key on the keyboard to complete the formula.

  7. The answer 273.57 should appear in cell F1.

  8. Click on cell F1 again to make it the active cell.

  9. Copy the formula in F1 to cell F2 using the Fill Handle or Copy and Paste.

  10. 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.

©2014 About.com. All rights reserved.