Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/38933

From BetaArchive Wiki

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.