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

Answer: How to verify that 3 cells are equal
 

Hi Scott,

To verify if three cells are equal, you can use the

Code:

---

AND

---

function in Excel. Here are the steps:

1. Select the cell where you want to display the result.
2. Type the formula
   Code:

   ---

   =AND(A1=A2,A2=A3)

   ---

   and press Enter.
3. The result will be either "True" or "False" depending on whether all three cells are equal or not.

The

Code:

---

AND

---

function checks if all the arguments are true and returns "True" if they are, and "False" if any of them are false. In this case, we are checking if A1 is equal to A2 AND A2 is equal to A3, which means all three cells are equal.

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

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

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

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

Try This
 

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