Blankety blanks

[Littlesaz]

I have a table with 20 columns. Several of the columns have key data without which the table is pointless. The others are the icing on the cake. I am not allowd to move the layout of the table around. In column 21 i want a word such as unacceptable to be inserted if data in columns 1, 5, 7, 9 are blank on that row. Any ideas? I have no idea about vba

 

[Peter_SSs]

Welcome to the MrExcel board!

Do you want "unacceptable" only if all 4 cells are blank, or if any of the the 4 cells is blank?

If filled, would these 4 cells contain numbers, text or either?

Do any of these cells contain formulas?

 

[T. Valko]

I have a table with 20 columns. Several of the columns have key data without which the table is pointless. The others are the icing on the cake. I am not allowd to move the layout of the table around. In column 21 i want a word such as unacceptable to be inserted if data in columns 1, 5, 7, 9 are blank on that row. Any ideas? I have no idea about vba

Maybe something like this...

=IF(COUNTA(A1,E1,G1,I1)<4,"Unacceptable","")

 

[Littlesaz]

I'm very happy now, works beautifully

 

[T. Valko]

I'm very happy now, works beautifully

I'm happy that you're happy!

Thanks for the feedback!