Microsoft Office Tutorials and References

In Depth Information

**Leaving Some Decimals Behind with TRUNC**

✓
INT(25.25) returns 25.

✓
INT(25.75) returns 25.

✓
INT(-25.25) returns –26.

✓
INT(-25.75) returns –26.

Here’s how to use the INT function:

1. In a cell of your choice, enter a number that has a decimal portion.

2. Position the cursor in the cell where you want the results to appear.

3. Enter
=INT(
to begin the function entry.

4. Click the cell where you entered the number.

5. Enter a closing parenthesis to end the function, and press the Enter key.

INT can also be used to return just the decimal part of a number. Subtracting

the integer portion of a number from its full value leaves just the decimal as

the answer. For example, 10.95-INT(10.95) equals 0.95.

Leaving Some Decimals

Behind with TRUNC

The TRUNC function drops a part of a number. The function takes two

arguments. The first argument is the number to be changed. The second

argument indicates how much of the number is to be dropped. A value of 2 for the

second argument says to leave 2 decimal places remaining. A value of 1 for

the second argument says to leave 1 decimal place remaining.

TRUNC does no rounding as it truncates numbers. Here are some examples:

✓
=TRUNC(212.65, 2) returns 212.65.

✓
=TRUNC(212.65, 1) returns 212.6.

✓
=TRUNC(212.65, 0) returns 212.

You can even use TRUNC to drop a portion of the number from the integer

side. To do this, you enter negative values for the second argument, like this:

✓
=TRUNC(212.65, -1) returns 210.

✓
=TRUNC(212.65, -2) returns 200.