=DEVSQ(A1:D1)=0

Now that's thinking outside the box. Very nice.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Dana DeLouis" wrote in message
...
Maybe another option if all cells are numbers:

=DEVSQ(A1:D1)=0

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"RagDyer" wrote in message
...
Slightly shorter:

=AND(A1=B1,B1=C1,C1=D1)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jshendel" wrote in message
...
works well. Long equation, but it works.
Thanks!

"Trevor Shuttleworth" wrote:

one way

=IF(AND(A1=B1,B1=C1, C1=D1),"true","false")

Regards

Trevor


"Jshendel" wrote in message
...
is it possible to have this type of equation?
=if(a1=b1=c1=d1,"true","false")
I don't want to just find the sum of these cells because there may be
other
instances where they do equal a sum, but are not equal to each other.
1 1 1 1 (right)
4 0 0 0 (wrong)