Need help with IF(AND / OR

[Mukesh]

Sheet1!L53 = true or false
Sheet1!L56 = true or false
Sheet1!L59 = true or false

so how do I get :

if all true = good
if all false = not good
if any 2 are true = better
if any 2 are false = slightly better

I tried IF(AND / IF(OR(, but don't seem to be doing it right, please help.

Thanks.
Mukesh

 

[Jacob Skaria]

Try

=LOOKUP(SUM(L53+L56+L59),{0,1,2,3},{"NOT GOOD","SLIGHTLY
BETTER","BETTER","GOOD"})

 

[Gary''s Student]

=CHOOSE(Sheet1!L53+Sheet1!L56+Sheet1!L59+1,"not good","slightly
better","better","good")

 

[Mukesh]

Thank you Jacob & Gary's Student.

If you don't mind can you please elaborate the formula a bit more, so
that I can figure it out myself next time.

Thanks.
Mukesh