If command across multiple cells

Hi Guys,

I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple cells.

This is what I have now with the end true_false value in cell L6

=IF(K6="Y","YES",IF(K6="N/A","YES","NO"))

So this works fine when just looking at K6

However I would like it to look at having Y or N/A across cells C6:K6 before giving yes otherwise false value should be NO.

Thanks in advance