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

Try

=LOOKUP(SUM(L53+L56+L59),{0,1,2,3},{"NOT GOOD","SLIGHTLY
BETTER","BETTER","GOOD"})
--
If this post helps click Yes
---------------
Jacob Skaria


"Mukesh" wrote:


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

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

--
Gary''s Student - gsnu200849

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



"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200849