Need Help with nested if statement

[johnnygirl51]

I would like some help with a nested If function. I need a formula that can help me do the following:
If the value in cell S2=0, then say No Opportunities
If the values in G2 or H2 =0.00%, then say No Goal
If V2>G2, Goal Met, if V2<G2, Not Met
If W2>H2, Goal Met, if W2<H2, Not Met

Is this possible with a nested IF function and, if so, what would the formula look like?

[Ace_XL]

=IF(S2=0,"No Opportunities",IF(OR(G2=0,H2=0),"No Goal",IF(OR(V2>G2,W2>H2),"Goal Met",IF(OR(V2<G2,W2<H2),"Not Met",""))))

[FDibbins]

it would start off something like this...

=if(S2=0,"No Opp",if(or(G2=0,h2=0),"No Goal",if(V2>G2,"Met","Not Met............
but you have left out a lot of options, such as...
what to do is S2<>0
what to do if G2 or H2 <>0
etc

[johnnygirl51]

Thank you so very much for this help!!!! This gets me very close to where I need to be and it's not 100% only because I realized I didn't make everything perfectly clear. It's working except in some instances it is returning No Goal because one of the goal columns may equal zero. If there is a goal for group 1 (a value greater than 0,00% in G2) then I need that value compared to the value in V2, regardless if there is a goal in H2. The reverse is also true. I provided an example that will hopefully make this clear. So, if the value in G2 is 0.00%, then there is No Goal for Group 1, if it is greater than 0.00%, then it should be compared to the value in V2, if V2>G2, Goal Met (for group 1), if V2<G2, Goal Not Met. At the same time, if the value in H2 is 0.00%, then there is No Goal for Group 2, if it is greater than 0.00%, then it should be compared to the value in W2, If W2>H2, Goal Met, if W2<H2, Not Met. I am so very sorry this wasn't clear the first time and so VERY appreciative of the help!!!!!!
placements example.jpg

[Ace_XL]

Ok..maybe this??

For group 1
=IF(S2=0,"No Opportunities",IF(G2=0,"No Goal",IF(V2>G2,"Goal Met",IF(V2<G2,"Not Met",""))))

For group 2
=IF(S2=0,"No Opportunities",IF(H2=0,"No Goal",IF(W2>H2,"Goal Met",IF(W2<H2,"Not Met",""))))