Microsoft KB Archive/38933: Difference between revisions
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q38933 to Microsoft KB Archive/38933 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:22, 12 August 2020
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.