formulas

[ericlch16]

I have all these columns
A B C D E F G H I

in column J i want a formula such that it returns "No comments entered" if all A, B, D, E, G, I are empty?

what is the best way to do this without nested loop?

thanks

 

[Sal Paradise]

=IF(LEN(A1&B1&D1&E1&G1)=0,"No Comments Entered","")