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