View Single Post
  #6   Report Post  
Nawaz Shaikh Nawaz Shaikh is offline
Junior Member
 
Posts: 1
Default Try This

Quote:
Originally Posted by Scott View Post
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
TRY THIS....

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

subscribe my channel NSINTELLECT on youtube
https://www.youtube.com/channel/UCxl...u4fuqVgK_j5Yiw