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:

=INT(SUM(D3:D5))

The INT function effectively drops the decimal portion, .60, and just returns

the integer part, 211. The project estimate is $211.

Figure 7-7:

Using INT

to drop

unnecessary

decimals.

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

examples: