Help with IF statement

[D_Spark]

Can some please help with my IF Statement?

=IF(F24=1,IF(C24>0,IF(D24>0,IF(E24>0,"Outstanding"),IF(F24=1,IF(C24>0,IF(D24>0,IF(E24=0,"Exceeds Expectation")))))))

I wish for the If statment to do the following

first IF
F24=1
c24>0
d24>0
e24>0
then show "Outstanding"

second IF
F24=1
c24>0
d24>=0
E24=0
then show "Exceeds Expectation"

second IF
F24<1
and any other permitation
then show "Does Not Meet Expectation"

 

[JackDanIce]

What if F24>1?

 

[D_Spark]

It will never be as F24 is a percentage restricted to 100%

 

[JackDanIce]

Try:

=IF(F24<1,"Does not meet expectations",IF(AND(C24>0,D24>0,E24>0),"Outstanding",IF(AND(C24>0,D24>=0,E24=0),"Exceeds Expectation")))

I think though it may fail as it doesn't take into consideration all your permutations...

 

[Airfix9]

Can some please help with my IF Statement?

=IF(F24=1,IF(C24>0,IF(D24>0,IF(E24>0,"Outstanding"),IF(F24=1,IF(C24>0,IF(D24>0,IF(E24=0,"Exceeds Expectation")))))))

I wish for the If statment to do the following

first IF
F24=1
c24>0
d24>0
e24>0
then show "Outstanding"

second IF
F24=1
c24>0
d24>=0
E24=0
then show "Exceeds Expectation"

second IF
F24<1
and any other permitation
then show "Does Not Meet Expectation"

Based on that, does this not work?

=IF(AND(F24=1,C24>0,D24>0,E24>0),"Outstanding",IF(AND(F24=1,C24>0,D24>=0,E24=0),"Exceeds Expectation","Does Not Meet Expectation"))