Mac Works: Rounding to a Set Limit

PSS ID Number: Q24719 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

###### ==========================================================

The information in this article applies to: |

- Microsoft Works for the Macintosh, versions 1.x, 2.x, 3.x and 4.0 |

# SUMMARY

In a Microsoft Works spreadsheet, to round a number to a set limit (for example, to the nearest .05), use the following formula:

=ROUND(value1*(1/value2),0)*value2

# MORE INFORMATION

In the above formula, “value1” is the value (or reference of the value) to be rounded, and “value2” is the value to round to. For example, if value1 = 14.37 and value2 = .05, the result would be 14.35.

KBCategory: kbusage KBSubcategory: macworkskb

# Additional reference words: 1.00 1.10 2.0 3.0 4.0 mwksss

Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.