Microsoft KB Archive/38933

Works: ROUND Function Error with 0 (Zero) for Argument

PSS ID Number: Q38933 Article last modified on 06-10-1996

2.00

MACINTOSH

Summary:

In a Microsoft Works version 2.00 spreadsheet, if the ROUND function is supplied with an argument of zero (0), it will return an error message.

For example, if cell A1 contains “0” and cell A2 contains “=ROUND(A1,2)”, cell A2 will return “Error”.

To correct the problem, add a very small number, such as .00000000001, to the argument in the ROUND function. For example, the formula above would read “=ROUND(A1+.00000000001,2)”.

Microsoft has confirmed this to be a problem in Works version 2.00. This problem was corrected in Works version 2.00a.

KBCategory: kbbuglist kbfixlist KBSubcategory: macworkskb

= Additional reference words: 2.00 =

Copyright Microsoft Corporation 1996.