I need to simplify this...
 

OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)

I need to simplify this...
 

=(COUNTIF(EB6:EE6,"<4.5%")+COUNTIF(EH6:EI6,"<4.5%" ))0


"j5b9721" wrote:

OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)

I need to simplify this...
 

It dose not help me...

"Teethless mama" wrote:

=(COUNTIF(EB6:EE6)<4.5%)+COUNTIF(EH6:EI6)<4.5%))0


"j5b9721" wrote:

OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)

I need to simplify this...
 

I'm pretty sure we need just a "little" more feedback than "it does not
help". Maybe telling us why it does not help might be a good start.

--
Rick (MVP - Excel)


"j5b9721" wrote in message
...
It dose not help me...

"Teethless mama" wrote:

=(COUNTIF(EB6:EE6)<4.5%)+COUNTIF(EH6:EI6)<4.5%))0


"j5b9721" wrote:

OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)

I need to simplify this...
 

You can reduce it to an array**

OR(EB6:EE6<4.5%,OR(EH6:EI6<4.5%))

** 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.

Note that an empty cell will evaluate to be <4.5%.


--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)

I need to simplify this...
 

=MIN(EB6:EE6,EH6:EI6)<4.5%
--
David Biddulph

j5b9721 wrote:
OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI 6<4.5%)