using IF and AND and OR

[AwesomeSteph]

Say cell E2 needs a formula that will produce a "yes" or a "no". if C2 and D2 are empty E2 should also be empty. If C2 and D2 have a no in either cell E2 should say "NO" if both have a yes or a "NO CHANGE" in both cells E2 should say "yes". I'm not sure why I can't make this work. Any suggestions are much appreciated!

 

[James006]

Hi,

An initial test would be =IF(AND(C2="",D2=""),"",IF(OR(C2="No",D2="No"),"No","Yes"))

Hope this will help

 

[mole999]

are you using it as case sensitive

and testing for all possibilities

Excel Workbook
	K	L	M	N	O
11
12		Table
13
14		no		NO
15			no	NO
16		no	no
17		yes	yes	YES
18		no change	no change	YES
19		yes	no change	YES
20		no change	yes	YES
21		no change
22		yes
23			no change
24			yes
25
Sheet1

 

[AwesomeSteph]

So this did work exactly the way I originally explained but once I started testing it I realized that what I need is a bit more complex.
E column should show "YES" if C and D have either both "YES" or both "NO CHANGE" really either or however if either C or D have a "NO" then E should also return with "NO" but if both C and D have "NO CHANGE" then E should show "NO"

 

[mole999]

concatenating with & might make the task easier to expand quickly

=IF(D11&E11=LOWER("no"),"NO",IF(D11&E11=LOWER("nono"),"NO","ALT"))