Test 2 numbers
Shane,
You missed a major disadvantage of DELTA is that it can only take 2
arguments and would become more trouble than it's worth with the fiddling
about you'd have to do when trying to evaluate more than 2. The only reason I
offered it was because th OP specified 2 numbers.
We'll disagree about whether =(A1=B1)+1 can handle text, I remain of the
opinion it can :)
Mike
"Shane Devenshire" wrote:
Hi,
One advantage in using COUNTIF is that it will work for Text, Numbers, or
Dates
One advantage in using =1+(A1=A2) or DELTA is that the cells don't need to
be adjactent, but both of these don't work for text.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Dave" wrote:
Hello,
two number in (say) a1 & b1
In another cell If the numbers are different how can i get Excel to return
1 or if the numbers are the same 2
d
|