LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Equal Cells ThomP Excel Worksheet Functions 4 August 4th 09 05:43 PM
setting multiple cells equal to other cells bijoutery Excel Worksheet Functions 2 December 8th 08 03:33 PM
Sum equal cells Jaimi Blazek Excel Worksheet Functions 2 October 29th 07 07:31 PM
how to seperate cells with equal blank cells yaling Excel Discussion (Misc queries) 9 May 13th 07 07:04 PM
if two cells are equal? Clagge New Users to Excel 2 July 29th 05 11:41 AM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"