Remember Me?

#1
November 9th 04, 10:08 PM
 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

#2
November 9th 04, 10:16 PM
 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

#3
November 9th 04, 10:21 PM
 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

#4
November 9th 04, 11:38 PM
 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

#5
November 9th 04, 11:47 PM
 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

#6
January 30th 20, 01:41 PM
 Junior Member First recorded activity by ExcelBanter: Jan 2020 Posts: 1
Try This

Quote:
 Originally Posted by Scott 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

 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 05:33 AM.