• Share

Discuss in my forum

# Excel INT Function

## Rounding Numbers in Excel

Excel INT Function

© Ted French

The INT function is used to round a number downwards towards the next lowest number.

INT is similar to the ROUNDDOWN function except that it always rounds a number down to the nearest whole number - completely removing the decimal portion.

The ROUNDDOWN function, on the other hand, will round a number down to a desired number of decimal places.

The syntax for the INT function is:

= INT ( Number)

Number - the value to be rounded. This can also be a cell reference to the location of the number in the spreadsheet.

### Example Using Excel's INT Function:

For help with this example, see the image above.

1. Enter the following data into cell D1: 34.567

2. Click on cell E1 in the spreadsheet - this is where the function will be located.

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

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

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

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

7. Click on cell D1 in the spreadsheet to enter that cell reference into the dialog box.

8. Click OK.

9. The answer 34 should appear in cell E1.

10. When you click on cell E1 the complete function = INT ( D1 ) appears in the formula bar above the worksheet.

Related Tutorials
##### Excel How To Series

Ted French
About.com Spreadsheets

See More About
Explore Spreadsheets
See More About:
By Category
1. About.com
2. Computing
3. Spreadsheets
4. Excel Functions
5. Rounding Number Functions
6. INT Function - Excel 2007 INT Function