Excel Tutorial – INT

The INT function in Microsoft Excel is a function that rounds a number down to the nearest integer. This function is useful for formatting numbers and making them easier to read and understand.

To use the INT function, follow these steps:

1. Open Microsoft Excel and select the cell where you want the rounded number to appear.
2. Type the following formula into the cell: =INT(number)
3. Replace “number” with the number that you want to round down to the nearest integer.
4. Press Enter to see the result.

The INT function always rounds numbers down to the nearest integer, regardless of their value. For example, if a number is halfway between two whole numbers, the INT function will round it down to the lower number.

You can also use the ROUND, ROUNDUP, and ROUNDDOWN functions to round a number to the nearest whole number, or up or down to a specified number of decimal places, respectively.

The INT function is a very useful tool for formatting numbers and making them easier to read and understand. You can use it to round numbers down to the nearest integer, or to the nearest whole number.