Remember Me?

 Scott Posts: n/a 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?

-Scott

 Frank Kabel Posts: n/a 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?

-Scott

 Bart Snel Posts: n/a 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?

-Scott

 Dana DeLouis Posts: n/a 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?

-Scott

 Dana DeLouis Posts: n/a 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?

-Scott

 Nawaz Shaikh Junior Member First recorded activity by ExcelBanter: Jan 2020 Posts: 1 Try This

Quote:
 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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post emerb Excel Discussion (Misc queries) 5 January 4th 05 04:42 PM Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM KHarrison Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM

All times are GMT +1. The time now is 12:24 PM. Copyright ©2004-2020 ExcelBanter.