J
j5b9721
OR(EB6<4.5%,EC6<4.5%,ED6<4.5%,EE6<4.5%,EH6<4.5%,EI6<4.5%)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=(COUNTIF(EB6:EE6,"<4.5%")+COUNTIF(EH6:EI6,"<4.5%"))>0
J
j5b9721
It dose not help me...
Teethless mama said:=(COUNTIF(EB6:EE6)<4.5%)+COUNTIF(EH6:EI6)<4.5%))>0
R
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.
help". Maybe telling us why it does not help might be a good start.
T
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%.
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%.