Microsoft KB Archive/63024

Works: ERR Function Gives Incorrect Response

PSS ID Number: Q63024 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SYMPTOMS =

When using the ERR function in a Works Spreadsheet, Works appears to give an incorrect response when one of the cells being referenced by the ERR function contains a mathematical formula. This is not a problem with the way the ERR statement is set up, it is a rounding error. This causes the ERR to be returned and never change.

To reproduce this problem, add three cells together by entering the SUM function in cell D16. Put a text number in cell D17 equaling the total in D17. Perform the ERR function on those two cell by entering the following:

=ERR(D17=D16,1,ERR)

Instead of returning a 1 signifying they are equal, Works will return an ERR indicating that they are not equal. This is due to the rounding error found in the SUM function.

= WORKAROUND =

To work around this problem incorporate the ROUND function into the SUM function cell (D17) as follows:

=ROUND(SUM(D14:D16),2)

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: dwksss =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.