If command across multiple cells

Closed
CuriousBaz Posts 1 Registration date Tuesday 17 December 2013 Status Member Last seen 17 December 2013 - 17 Dec 2013 à 03:56
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 18 Dec 2013 à 23:18
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
18 Dec 2013 à 23:18
not clear

copy L6 and paste to any other cell