I need to simplify this...

[j5b9721]

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

 

[Teethless mama]

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

 

[j5b9721]

It dose not help me...

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

 

[Rick Rothstein]

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.

 

[T. Valko]

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