I am trying to comapre a cell value to a list using the following function- "=OR(EXACT(A3,B3:B8))"

I have the following info in excel. In C2 I have the following function -

=OR(EXACT(A3,B3:B8))

I am checking to see if the Cell "10222" is contained in the List, which it is. But the function is returning "False"

If I put 10222 into the first cell, it returns "True"

The interesting thing, when I check the function dialog box for the first example.

The dialog box shows that the function is "True"

Formula Result = True

The result string is actually (False, True, False, False, False, False...) If any one of the conditions is "true" the result should be "true". The formula shows the result is true, but "False" is what is displayed back in the formula cell.

In addition, if I use the "Evaluate Formula" tool in Excel 2007 and walk through the formula. Only the first item in the list is getting compared to the cell, and this tool shows the result is "False"

Is this a bug, or is this happening for a reason?

Thanks for any input,

**Cell****List**1022210200FALSE 10222 10225 13524 54236 12265I have the following info in excel. In C2 I have the following function -

=OR(EXACT(A3,B3:B8))

I am checking to see if the Cell "10222" is contained in the List, which it is. But the function is returning "False"

If I put 10222 into the first cell, it returns "True"

**Cell****List**1022210222TRUE 10222 10225 13524 54236 12265The interesting thing, when I check the function dialog box for the first example.

**Cell****List**1022210200FALSE 10222 10225 13524 54236 12265The dialog box shows that the function is "True"

Formula Result = True

The result string is actually (False, True, False, False, False, False...) If any one of the conditions is "true" the result should be "true". The formula shows the result is true, but "False" is what is displayed back in the formula cell.

In addition, if I use the "Evaluate Formula" tool in Excel 2007 and walk through the formula. Only the first item in the list is getting compared to the cell, and this tool shows the result is "False"

Is this a bug, or is this happening for a reason?

Thanks for any input,

Last edited: