Microsoft Office Tutorials and References
In Depth Information
Leaving All Decimals Behind with INT
INT comes in handy when all you need to know is the integer part of a
number or the integer part of a calculation’s result. For example, you may be
estimating what it will cost to build a piece of furniture. You have the prices
for each type of raw material, and you just want a ballpark total.
Figure 7-7 shows a worksheet in which a project has been set up. Column
A contains item descriptions, and Column B has the price for each item.
Columns C and D contain the parameters for the project. That is, Column C
contains the count of each item needed, and Column D has the amount of
how much will be spent for each item, that is the price per item multiplied by
the number needed of the item.
The sums to be spent are then summed into a project total. If you added the
item sums as they are — 83.88, 107.76, and 19.96 — you get a total of $211.60.
Instead, the INT function is used to round the total to a ballpark figure of $211.
In cell D8, INT is applied to the total sum, like this:
The INT function effectively drops the decimal portion, .60, and just returns
the integer part, 211. The project estimate is $211.
INT takes only the number as an argument. INT can work on positive or
negative values, but works a little differently with negative numbers. INT actually
rounds down a number to the next lower integer. When working with positive
numbers the effect appears the same as just dropping the decimal. With
negative numbers the effect is dropping the decimal portion, then subtracting 1.
With negative numbers, the function produces an integer that is farther away
from 0. Therefore, a number such as –25.25 becomes –26. Here are some