If command across multiple cells

[Closed]
Report
Posts
1
Registration date
Tuesday December 17, 2013
Status
Member
Last seen
December 17, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
not clear

copy L6 and paste to any other cell