IF.....

G

George

Dear all,

The formula below is ok, but only for one row. How to use it for range of
rows?

=IF(IF(COUNTA(C4:AV4)=0;1;(SUMPRODUCT((A4>0)*(B4>0)*1)))=1;"OK";"NOT OK")

Thank you in advance,

George
 
F

Fred Smith

Like this:
=IF(IF(COUNTA(C4:AV5)=0;1;(SUMPRODUCT((A4:A5>0)*(B4:B5>0)*1)))=1;"OK";"NOT
OK")

Regards,
Fred
 
Top