Microsoft KB Archive/62142

Works: Zero or Blank Denominator Returns “ERR”

PSS ID Number: Q62142 Article last modified on 10-22-1998

1.0 1.05 2.0 | 4.0

MACINTOSH MS-DOS

=
=========================================================

= SUMMARY =

If the value of a cell used as the denominator of a division is zero or blank, the result of the division will be “ERR” or “Error” in Works for MS-DOS and “Error” in Works for the Macintosh. In this case, “ERR” or “Error” indicates infinity, which is the correct result of division by zero.

To prevent “ERR” or “Error” from appearing, use the IF function to check for zero or blank entries. For example, to divide A1 by B1, check for a zero or blank in B1 as follows:

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

When B1 equals zero, the function returns a zero. When B1 does not equal zero, the division A1/B1 is performed.

KBCategory: kbother KBSubcategory: dworkskb macworkskb

= Additional reference words: macintosh mac m_works =

Version : 1.0 1.05 2.0 | 4.0 Platform : MACINTOSH MS-DOS Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.