How to verify that 3 cells are equal


G

Guest

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
 
Ad

Advertisements

B

Bart Snel

Try this one:

=IF(A1=A2;IF(A2=A3;TRUE;FALSE);FALSE)

Bart Snel
 
D

Dana DeLouis

Just another idea...

=VAR(A1:A3)=0
or
=DEVSQ(A1:A3)=0

HTH
 
Ad

Advertisements

D

Dana DeLouis

Oops. Forgot to mention another option:
=VARA(A1:A3)=0

This will return False if one of your numbers happens to be text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to verify that 3 cells are equal 1
1 equals 3 2
Equal Cells 2
Cell Equality 5
Cells equal a number 3
Sum equal cells 2
Painting equal cells 2
equals merged cells 2

Top