if a1=b1=c1=d1....
 

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)

if a1=b1=c1=d1....
 

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)

if a1=b1=c1=d1....
 

I have always found nested if statements quite useful

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


"Jshendel" wrote:

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)

if a1=b1=c1=d1....
 

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)

if a1=b1=c1=d1....
 

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)

if a1=b1=c1=d1....
 

Hadn't realised you were looking for brevity too ;-)


"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)

update file
 

Can it be possible ?
In a two different excel file if i update one file other one update
automatic.with specify coloums

kindly guide me

if a1=b1=c1=d1....
 

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)

if a1=b1=c1=d1....
 

On Fri, 8 Dec 2006 13:00:02 -0800, Jshendel
wrote:

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)

The array formula:

=SUM(1/COUNTIF(rng,rng))=1

(entered with <ctrl<shift<enter)

will return TRUE if they are all equal, FALSE if they are not, and result in a
DIV/0 error if there are blank cells.

You can test for the DIV/0 error if that is a problem.

rng can be any one dimensional range of cells that does not include an entire
column.
--ron

update file
 

Not without a lot of work to create a macro--and lots can be changed that would
be difficult to foresee (in my opinion).

I always try to keep my data in one location.

Basant wrote:

Can it be possible ?
In a two different excel file if i update one file other one update
automatic.with specify coloums

kindly guide me

--

Dave Peterson

if a1=b1=c1=d1....
 

=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)

if a1=b1=c1=d1....
 

Hi. Thanks Chip! Another version might be the following:

=COUNTIF(A1:D1,A1)=4

The advantage here is that it will test for equality among text also.
A blank cell mixed in will also trigger False.
One catch with COUNTIF is that it will trigger False if all are blank.
--
Dana DeLouis


"Chip Pearson" wrote in message
...
=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)

if a1=b1=c1=d1....
 

Hi Dana

The slight problem with the DEVSQ method, is also that any blank(s) will
also trigger a false True result.

--
Regards

Roger Govier


"Dana DeLouis" wrote in message
...
Hi. Thanks Chip! Another version might be the following:

=COUNTIF(A1:D1,A1)=4

The advantage here is that it will test for equality among text also.
A blank cell mixed in will also trigger False.
One catch with COUNTIF is that it will trigger False if all are blank.
--
Dana DeLouis


"Chip Pearson" wrote in message
...
=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)