Help With If Statement

[PZim]

Hello All, I am by no means an expert when it comes to formula's so I need some guidance with this one. What I am trying to accomplish is if I9 result is yes, J9 result is no and K9 result is no, then I want the end result to be either Yes

What am I doing wrong ?

=IF(I9=Yes, IF(J9=No,IF(K9=No,"Yes")))

[Jonmo1]

Your sentence seems to be cut short..
You were saying
"then I want the end result to be either Yes" ... Or What ??

It sounds like you only want YES if I9=Yes and both J9 and K9 = No
Otherwise, you want No

Is that about right?

[loginjmor]

Hi -

You need to enclose Yes in quotes in the first term and No in quotes in the second and third term. Should look like this:

=IF(I9="Yes", IF(J9="No",IF(K9="No","Yes")))

[PZim]

Jonmo1,

Yes, you are correct, I want the end result to be Yes, not either

[Jonmo1]

Try

=IF(AND(I9="Yes",J9="No",K9="No"),"Yes","No")

[PZim]

Oh my Gosh, I did not even see that I was missing the " " . Thank you.

One more thing however. If I want to take this a step further .... If I9 is Yes and if J9 or K9 result is "no", then I want the end result to be NO. How do I formulate that ?

[Jonmo1]

Before going any further, can you specify all possible scenarios..

I9=Yes J9=Yes K9=Yes : I want ?
I9=Yes J9=Yes K9=No : I want ?
I9=Yes J9=No K9=Yes : I want ?
I9=Yes J9=No K9=No : I want ?
I9=No J9=Yes K9=Yes : I want ?
I9=No J9=Yes K9=No : I want ?
I9=No J9=No K9=Yes : I want ?
I9=No J9=No K9=No : I want ?

[PZim]

Oh My Goodness - How did I not know about this forum sooner. Thank you all!

[PZim]

Ok, one last scenario . For this formula I have below, if I want to take it a step further. I want this formula to calculate only if cell M9 result is "yes" . Otherwise I want the final result to be $0.00

=IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00"))))

[loginjmor]

Try:

=IF(M9="Yes",IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00")))),"")

[PZim]

Ok, one last scenario, I promise.... If cells J9 or K9 has results of "no" , then I want the final cell M9 to have a result of $0.00 and not perform the below calculation. The No's takes priority over the below.

=IF(M9="Yes",IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00")))),"")

[loginjmor]

OK, try this:

=IF(OR(J9="No",K9="No"),"$0.00",IF(M9="Yes",IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00")))),""))

[PZim]

loginjmor

I miss spoke, correction.....

If cells J9 or K9 has results of "Yes" , then I want the final cell M9 to have a result of $0.00 and not perform the below calculation. The Yes's takes priority over the below.

=IF(M9="Yes",IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00")))),"")

[loginjmor]

Just change the conditions in the formula to "Yes" as follows:

=IF(OR(J9="Yes",K9="Yes"),"$0.00",IF(M9="Yes",IF(N9>390,"$100.00",IF(N9>260,"$50.00",IF(N9>120,"$25.00",IF(N9<120,"$0.00")))),""))

This means both J9 and K9 must be "No" to evaluate M9.