Microsoft KB Archive/76436

From BetaArchive Wiki
Knowledge Base


Works: Division by Zero Causes "ERR"

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