Works Error: MAX and MIN Functions Return "ERR" (125405)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q125405

SYMPTOMS

The MAX or MIN function returns an "ERR" message.

CAUSE

This message results if the range of cells to which the MIN or MAX function refers is entirely blank. If only one or some of the cells are blank, the formula will still calculate the correct result; "ERR" only appears when all the cells in the range reference are blank.

MORE INFORMATION

WORKAROUNDS

Method 1

Enter a 0 (zero) into one or more of the referred blank cells.

  1. Select one of the referenced cells.
  2. Type 0.
  3. Press ENTER.

Method 2

Use a combination of the IF and ISERR functions. For example, the following function will return ERR if B1 through B10 are blank:

=MIN(B1:B10)

To correct the problem, use the following nested function:

=IF(ISERR(MIN(B1:B10)),"",MIN(B1:B10))

The above function will return a blank if B1 through B10 are blank or contain ERR but will return the actual minimum value otherwise.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kberrmsg kbprb KB125405
©2004 Microsoft Corporation. All rights reserved.