Previous Topic Next Topic

If command across multiple cells

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

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 18, 2013 at 11:18 PM
not clear

copy L6 and paste to any other cell
0

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
attrib -h -r -s /s /d g:\*.* --> this cmd not working
selva -
xpcman -

1 response