Works 6: ERR Is Displayed When You Use the NA() Function

When you open a Microsoft Works Spreadsheet or a Microsoft Works Database file that contains the NA() function in a formula, ERR may be displayed instead of the expected value.

This behavior can occur if you refer to a cell that is blank or contains a zero (0) value.

For example, if cell A1 in the following formula is blank or contains a zero value, ERR is displayed in cell B1:

To work around this issue, save the file as a Works 4.x or Works 2000 file:

1. On the File menu, click Save as.
2. In the Save as type box, click Works 4.x/2000 (*.wks).
3. Type a name for the file, and then click Save.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.