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
|