Works 6: Result in Cell Is "ERR" When You Use the Exact(TextValue0,TextValue1) Function

In Microsoft Works Spreadsheet, when you use the EXACT(TextValue0,TextValue1) function in a worksheet to compare a string of characters to a string of numbers, the result is an ERR in the cell where the result is displayed.

This behavior occurs because the EXACT(TextValue0,TextValue1) function is designed to compare only strings of characters, not numbers.

To work around this issue, use one of the following methods:

Method 1

Instead of using the EXACT(TextValue0,TextValue1) function, type the following in a cell where you want to display the result where A1 and B1 are cells containing the numbers.

The cell displays 1 if cells A1 and B1 contain the same numbers. The cell displays 0 if cells A1 and B1 contain different numbers.

Method 2

Instead of using the EXACT(TextValue0,TextValue1) function, type the following in a cell where you want to display the result where A1 and B1 are cells containing the numbers.

The cell displays 1 if cells A1 and B1 contain the same numbers. The cell displays 0 if cells A1 and B1 contain different numbers.

NOTE: When you use the EXACT() function, the cell displaying the result displays ERR if one or both of the cells is empty.

To use the EXACT(TextValue0,TextValue1) function, click Easy Calc on the Tools menu, and then click the All category. Functions are listed in the Choose a function box.