We can use Excel to calculate mathematics and round numbers down to their integers. This is made possible by the use of the Excel INT function. In this post, we shall examine how we can use the Excel integer function to get the integer part of a number.
Figure 1: Excel INT function
Note that the INT function will only return the integer part of a decimal number. Also, we need to remember that the integer formula will round down a number so that those that are negative numbers will become more negative as seen in cell C9 of figure 1 above.
The integer formula
- Number– this is the number from which you want to get an integer.
The INT function will only round numbers down to the next lowest integer value.