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