Just another idea...
=VAR(A1:A3)=0
or
=DEVSQ(A1:A3)=0
HTH
--
Dana DeLouis
Win XP & Office 2003
"Scott" wrote in message
...
This has got to be an easy one but I can't figure it out. Can someone tell
me
how to verify if three cells are equal.
Example:
A1= 2
A2= 2
A3= 2
I can verify that two cells are equal by merely typing =A1=A2 and Excel
will
return "True" or "False." If I input the formula =A1=A2=A3, Excel returns
"False" even if all three values are equal. Any ideas?
Thanks in advance for your help.
-Scott
|