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.
- Enter the following data into cell D1: 34.567
- Click on cell E1 in the spreadsheet - this is where the function will be located.
- 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 spreadsheet to enter that cell reference into the dialog box.
- Click OK.
- The answer 34 should appear in cell E1.
- When you click on cell E1 the complete function = INT ( D1 ) appears in the formula bar above the worksheet.