Simple logic formula that is troubling me

[j_sun]

Hi All,

I've spent enough time struggling with what I know should be a simple task so I'm turning to the experts.


What is the best way to accomplish this:


If cell A <> "good", display value in cell A

If cell A = "good" AND cell B = "good", display "good"

If cell A = "good" AND cell B <> "good" display "bad"


I think that gives you the idea.


Thanks,

Jason

 

[Luke M]

Assuming the only options for A and B are Good/Bad, this will work:

=IF(OR(A2<>"Good",B2="Good"),"Good","Bad")


Otherwise,

=IF(A2<>"good",A2,IF(B2="good","good","bad"))

 

[Hui]

J_Sun

=IF(A1<>"Good",A1,IF(AND(A1="Good", B1="Good"),"Good",IF(AND(A1="Good",B1<>"Good"),"Bad","Something else")))

edit: I actually like Lukes formula better

 

[j_sun]

Thanks gents! Helpful as always.