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 |
Need help with IF(AND / OR
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 |
Need help with IF(AND / OR
=CHOOSE(Sheet1!L53+Sheet1!L56+Sheet1!L59+1,"not good","slightly
better","better","good") -- Gary''s Student - gsnu200849 |
Need help with IF(AND / OR
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 |
All times are GMT +1. The time now is 07:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com