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

=(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%)

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'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%)

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%)

=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%)