Microsoft KB Archive/76436

= Works: Division by Zero Causes &quot;ERR&quot; =

Article ID: 76436

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q76436



SUMMARY
If the denominator used in a division formula is 0, false, blank, or a text string, the result of the formula will be &quot;ERR.&quot;



MORE INFORMATION
A workaround is to use an IF formula to test for division by zero. For example, the formula

=IF(B1 = 0, 0, A1/B1)

will first test the cell B1 to see if it is zero. It will return a zero if B1 is a zero or perform the division if it is not a zero.

NOTE: Even though Works 3.0 and Works for Windows 95 support text string functionality in a formula, they will still return an &quot;ERR&quot; message if the denominator is a text string.

Additional query words: 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a w_works ss

Keywords: kbinfo KB76436

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.