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 "ERR."
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 "ERR" 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