Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equal Cells | Excel Worksheet Functions | |||
setting multiple cells equal to other cells | Excel Worksheet Functions | |||
Sum equal cells | Excel Worksheet Functions | |||
how to seperate cells with equal blank cells | Excel Discussion (Misc queries) | |||
if two cells are equal? | New Users to Excel |