Cell value depending if other cells have content

[chrishall166]

I have 10 cells, A1 to A10. They may or may not contain content.

In cell A11 I want to fill Y if any cell A1 to A10 contains any content and N if none of the cells A1 to A10 contain content.

What's the best way?

[#2 · Accepted solution]

@chrishall166 

In A11:

=IF(COUNTA(A1:A10)=0, "N", "Y")

[#3]

Thank you for the quick response!