IF OR RANGE CONDITIONING

[turkyildiz]

If I use

=IF(OR(B21>240,D21>118,C21>96),"NO YOU ARE OK","FOR SURE")

it does it for one row if I use


=IF(OR(B21:B43>240,D2143>118,C21:C43>96,E21:E43>4000),"FOR SURE","NO
YOU ARE OK")

does not do anything at all, any advise to get this formula to react
if i typle 244 in column b32 to turn to for sure

Regards

 

[JE McGimpsey]

One way:

=IF(COUNTIF(B21:B43,">240") + COUNTIF(C21:C43,">96") +
COUNTIF(D2143,">118") + COUNTIF(E21:E43,">4000"), "FOR SURE","NO YOU
ARE OK")