View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=AND(A1=A2,A2=A3)

--
Regards
Frank Kabel
Frankfurt, Germany

"Scott" schrieb im Newsbeitrag
...
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