Microsoft KB Archive/265940

= Works 6: Result in Cell Is &quot;ERR&quot; When You Use the Exact(TextValue0,TextValue1) Function =

Article ID: 265940

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * 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

=IF(A1=B1,1,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.

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 INFORMATION
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.

Additional query words: works6 w_works error

Keywords: kbaddin kbnofix kbprb KB265940

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.