Microsoft KB Archive/38933

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:22, 12 August 2020 by X010 (talk | contribs) (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/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.