Works 6: Result in Cell Is "ERR" When You Use the Exact(TextValue0,TextValue1) Function (265940)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works Suite 2001
This article was previously published under Q265940 SYMPTOMS
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.
CAUSE
This behavior occurs because the EXACT(TextValue0,TextValue1) function is designed to compare only strings of characters, not numbers.
RESOLUTION
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
=EXACT(STRING(A1,0),STRING(B1,0))
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.
MORE INFORMATIONNOTE: 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.
| Modification Type: | Major | Last Reviewed: | 10/7/2003 |
|---|
| Keywords: | kbAddIn kbnofix kbprb KB265940 |
|---|
|