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