Home 
Search 
Today's Posts 
#1




How to verify that 3 cells are equal
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 
#2




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 
#3




Try this one:
=IF(A1=A2;IF(A2=A3;TRUE;FALSE);FALSE) Bart Snel "Scott" schreef in bericht ... 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 
#4




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 
#5




Oops. Forgot to mention another option:
=VARA(A1:A3)=0 This will return False if one of your numbers happens to be text.  Dana DeLouis Win XP & Office 2003 "Dana DeLouis" wrote in message ... 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 
#6




Try This
Quote:
=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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Paste link versus allowing two cells equal each other?  Excel Discussion (Misc queries)  
To safety merge cells without data destroyed, and smart unmerge!  Excel Discussion (Misc queries)  
Heps to design Locked/Unlocked cells in protected worksheet  Excel Discussion (Misc queries)  
Convert data of cells to any type: Number, Date&Time, Text  Excel Discussion (Misc queries)  
How do I select a range if one cells contents is equal to another  Excel Discussion (Misc queries) 