Microsoft KB Archive/38933
Works: ROUND() Function Error with 0 (Zero) for Argument
PSS ID Number: Q38933 Article last modified on 06-10-1996
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.