Microsoft KB Archive/31295

Truncate a Decimal Number to Its Integer Part PSS ID Number: Q31295 Article last modified on 01-13-1989 PSS database name: D_MPlan

1.x 2.x 3.x 4.00

MS-DOS

Summary:

You can use the INT function to truncate a decimal value so that it becomes only the integer part of the value.

More Information:

For example, suppose the value 45.12345 is in R1C1 and you want the value in R2C1 to be the integer part of that value (i.e., 45). To accomplish this, do the following:


 * 1) Select R2C1.
 * 2) Type “V” (without the quotation marks) for Value or press “=” (the equals sign) so that you can enter the formula.
 * 3) Type INT(R1C1) and press ENTER.

The value 45 will appear as the returned value of this formula.

Copyright Microsoft Corporation 1989.