Nested If, AND, OR help I'm sure it's simple lol.

[bultm35431]

I need a cell to do this:

If G1 is greater than equal to 40 and H1 has MOON picked from the dropdown I1 needs to say SUCCESSFUL

If G1 is less than 40 and H1 has MOON picked from the dropdown I1 needs to say FAILED

If G1 is greater than equal to 40 and H1 does not have MOON picked from the dropdown I1 needs to say CLOSE

If G1 is less than 40 and H1 does not have MOON picked from the dropdown I1 needs to say TRY AGAIN

How would I go about doing that? Any ideas?

[Shareez Saleem]

IF(AND(G2>=40,H2="Moon"),"SUCCESSFUL",IF(AND(G2<40,H2="Moon"),"Failed",IF(AND(G2>=40,H2<>"Moon"),"CLOSE",IF(AND(G2<40,H2<>"Moon"),"TRY AGAIN",""))))

[bultm35431]

You are awesome!!! And saved me a significant amount of time thank you very very much!!!

[JohnTopley]

Try

=IF(H2="MOON",IF(G2>40,"SUCCESSFUL","FAILED"),IF(G2>40,"CLOSE","TRY AGAIN"))

[bultm35431]

Just thought of something this should only be active if there is something in A3? How would I make the formula dependent on something being in A3? I'll google as well

[JohnTopley]

Try

=IF(A3="","",IF(H2="MOON",IF(G2>40,"SUCCESSFUL","FAILED"),IF(G2>40,"CLOSE","TRY AGAIN")))

[bultm35431]

That formula does switch quite right it sort of works.

It needs to be if H2=MOON AND G2>= 40 then Successful
if H2=MOON AND G2<40 then Failed
if H2<>MOON and G2>=40 then Close
if H2 <>MOON and G2<40 then Try again

but only if A2 has something in it. I just can't figure out the syntax.............real close though

[JohnTopley]

=if(a2="","",if(h2="moon",if(g2>40,"successful","failed"),if(g2>40,"close","try again")))

[bultm35431]

Reps given thank you!!!

[JohnTopley]

Thanks for the feedback and reps.

If problem resolved could you mark thread as solved ("Thread Tools" at top of first post)