Eliminating if statements

[leviathan86]

I am not a fan of if statements, but have no clue how to rephrase this

=IF(I9="Yes",IF(J9="Yes","a",IF(K9="Yes","a",IF(L9="Yes","a",IF(M9="Yes","a","c")))),"c")

[Fotis1991]

Am i missing something? or this one does the same job?

Please Login or Register  to view this content.

[benishiryo]

hi leviathan86. maybe you can explain what you're trying to do. my guess is as long as I9 is a "yes" & any other cells from J9:M9 is a "Yes", then show "a". otherwise, show "c". if i'm right, try:
=IF(AND(I9="Yes",OR(COUNTIF(J9:M9,"yes"))),"a","c")

[leviathan86]

hi leviathan86. maybe you can explain what you're trying to do. my guess is as long as I9 is a "yes" & any other cells from J9:M9 is a "Yes", then show "a". otherwise, show "c". if i'm right, try:
=IF(AND(I9="Yes",OR(COUNTIF(J9:M9,"yes"))),"a","c")

You got it. Thanks I should have explained better.

CLOSED

[Fotis1991]

You got it. Thanks I should have explained better.

CLOSED

True is that you should!

So in this case.



You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Note that:Not marking your thread as SOLVED, is not an Option. Is violation of rule#9 of our Forum Rules.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Fotis1991]

Ok. This time you choose to ignore my suggestion for marking your thread as Solved. I'll do it this time.

Next time will not be a suggestion. Will be a request!

Thanks.