ARE ALL THE CELLS EQUAL?
 

Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

If A1 is not blank..the below will do

=IF(COUNTIF(A1:A10,A1)=ROWS(A1:A10),"All cells are same","Not same")

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

Here's another approach...

Array entered** :

=IF(AND(A1:A10=A1),"Same","Not the Same")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

Isn't there anyway for cells not in an array but distributed?
--
Best Regards,

Faraz


"Jacob Skaria" wrote:

If A1 is not blank..the below will do

=IF(COUNTIF(A1:A10,A1)=ROWS(A1:A10),"All cells are same","Not same")

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

Isn't there anyway for cells not in an array but distributed?
--
Best Regards,

Faraz



"T. Valko" wrote:

Here's another approach...

Array entered** :

=IF(AND(A1:A10=A1),"Same","Not the Same")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
--
David Biddulph

"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

XClent David!
Thanx!
--
Best Regards,

Faraz


"David Biddulph" wrote:

=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
--
David Biddulph

"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")

How did you know the data was numeric?


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
--
David Biddulph

"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz

ARE ALL THE CELLS EQUAL?
 

Inspired guesswork. :-)
--
David Biddulph

"T. Valko" wrote in message
...
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")

How did you know the data was numeric?


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(STDEV(D12, D7, E9, G2, H17, F11, I6)=0,"OK","OUT")
--
David Biddulph

"Faraz A. Qureshi" wrote in
message ...
Instead of entering a lengthy formula like:

=IF(OR(D12<D7,D7<E9,E9<G2,G2<H17,H17<F11,F11< I6),"OUT","OK")

Any idea how to determine if all the cells are equal by entering address
of
each cell once only, namely:
D12, D7, E9, G2, H17, F11, I6
or that of a range, like:
B1:B50
only once?

Thanx in advance.

--
Best Regards,

Faraz