| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
