View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Faraz A. Qureshi Faraz A. Qureshi is offline
external usenet poster
 
Posts: 211
Default 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