Thanks JE, Julie,

I changed the text format to number format and it works !!

"JE McGimpsey" wrote:

Disregard the last - it will return 2 if all three are equivalent.

In article ,
JE McGimpsey wrote:

When you entered your function, the cell was formatted as Text, so
that's how XL's parser interpreted it. Change the format and re-enter it.

FWIW, your formula could be a bit shorter by using XL's implicit
coercion of TRUE/FALSE to 1/0 in a math operation:

= --OR(A3=A2,A3=A4)

where the first - is used to coerce TRUE/FALSE to -1/0, then the second
- negates the result of the first.

Alternatively:

=(A3=A2)+(A3=A4)

but the -- is somewhat more efficient.