View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mukesh Mukesh is offline
external usenet poster
 
Posts: 78
Default Need help with IF(AND / OR


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