Formula for changing cell to "Completed" on non-blank cells

[psanghvi]

Hello all,

I was hoping to get some help on the formula to mark a certain cell as "Completed" the moment the adjoining row cells are non-blanks.

For ex: I have a database which has over 100 rows & columns a:e = which are always populated. Howver column f,g &h are to be user entered.

I want a formula in Column I where the moment all the columns in the pertinent row are populated including f,g,h the I should be marked as COMPLETED. Even if one of the cell in the pertient row - cells a:h is blank, the I should be ntoed as "PENDING".

Obviously, if all of the cells on that are row are blank - column I should be blank for that row.

Thanks!

 

[njimack]

=if(counta(f2:h2),if(counta(f2:h2)=columns(f2:h2),"completed","pending"),"")

 

[Ruddles]

Or possibly:-

=IF(COUNTA(A2:H2)=0,"",IF(COUNTA(A2:H2)<8,"pending","completed"))