Microsoft KB Archive/62380

Using the INT Function to Round Numbers in Multiplan PSS ID Number: Q62380 Article last modified on 06-14-1990 PSS database name: D_MPlan

1.04 1.06 1.10 1.20 2.00 2.01 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

In Multiplan it is possible to use the INT function to round; round up or round down, and to round to the nearest increment. The ROUND function is available for rounding to a specified number of decimal places. Multiplan version 4.20 has functions called ROUNDUP and ROUNDDOWN.

More Information:

The following are examples of rounding using the INT function. Assume for the purpose of these examples that the number contained in R3C3 is 4,565.555:

Rounding down to the nearest 100:

INT(R3C3/100)*100 equals 4,500.000

Rounding up to the nearest 100:

INT(R3C3/100 + .999999999) * 100 equals 4,600.000

Rounding to the nearest 100:

INT(R3C3/100 + .5) * 100 equals 4,600.000

Rounding to the nearest cent (nearest hundredth):

INT(R3C3*100 + .5) / 100 equals $4,565.56

Rounding down to the nearest 20:

INT(R3C3/20)*20 equals 4,560.000

Rounding up to the nearest 20:

INT(R3C3/20 +.999999999) * 20 equals 4,580.000

Rounding to the nearest 20:

INT(R3C3/20 + .5) * 20 equals 4,560.000

Copyright Microsoft Corporation 1990.