ExcelBanter - IF.....

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF..... (https://www.excelbanter.com/excel-discussion-misc-queries/234522-if.html)

George

IF.....

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((A40)*(B40 )*1)))=1;"OK";"NOT OK")

Thank you in advance,

George

Fred Smith[_4_]

IF.....

Like this:
=IF(IF(COUNTA(C4:AV5)=0;1;(SUMPRODUCT((A4:A50)*(B 4:B50)*1)))=1;"OK";"NOT
OK")

Regards,
Fred

"George" wrote in message
...
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((A40)*(B40 )*1)))=1;"OK";"NOT OK")

Thank you in advance,

George

All times are GMT +1. The time now is 12:24 AM.