Need help with IF(AND / OR

M

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
 
J

Jacob Skaria

Try

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

Gary''s Student

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

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
 
Top