If/Then statement

[osaben]

I am looking for some expertise on a formula in cell E15 that would look at data in cell A1 or A2 ad return an answer.


[TABLE="width: 245"]
<tbody>[TR]
[TD="width: 326, bgcolor: transparent, colspan: 3"]Cell #A1 – can possibly be blank, YES, NO or NA
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 3"]Cell #A2 – can possibly be blank, YES, NO or NA




[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 3"]If either A1 or A2 is blank; then leave cell blank.
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 3"]If both A1 and A2 are YES; then “Separate”
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 3"]IF only A2 is YES; then “Terminate”
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, colspan: 3"]If both A1 & A2 are NO; the “Add”
[/TD]
[/TR]
</tbody>[/TABLE]

Please and Thank You in advance for your help!

 

[dheeraj27]

=IF(OR(A1="",A2=""),"",IF(AND(A1="yes",A2="yes"),"Separate",IF(A2="yes","terminate",IF(AND(A1="no",A2="no"),"Add"))))

 

[osaben]

Thanks for your willingness to help dheeeraj27.

This solution seems to work for when both A1 and A2 are both yes or no. However when only A2 is yes, it returns FALSE rather than "Terminate"