Microsoft KB Archive/62896

Works: Deriving an Integer with Increment Greater Than One

PSS ID Number: Q62896 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother round

= SUMMARY =

It is possible to obtain an integer with an increment of greater than one using the INT function in Works. This procedure is commonly referred to as “rounding down to the nearest xx”, where “xx” is an integer (the ROUND function does not apply to this manipulation).

To derive an integer with an increment greater than one, use the following formula:

=INT(A1/XX)*XX

In the formula above, “A1” is a cell reference, and “XX” is an integer representing the increment to be derived.

Example 1:

Let A1 = 1647 INT(A1/50)*50 = 1600

Example 2:

Let A1 = 1689 INT(A1/50)*50 = 1650

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.