If formula with conditions for 3 statements

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,



I am looking for help in coming up with 3 staments.

If meets > does not meet and >exceeds = meets

If does not meet > exceeds and> meets = DNM

If exceeds > meets and> does not meet = Exceeds

Thank you for your help

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
No idea what are you asking but this should help. This are various way you can build IF statement. Just be aware that you may NOT have more than 7 nested IF (IFs statement, within other IF statement)


=IF(Cond, showThisForTrue, ShowThisForFalse)

=IF(AND(cond1, cond2), showThisForBothTrue, ShowThisForEitherFalse)


=IF(OR(cond1, cond2), showThisForEitherTrue, ShowThisForBothFalse)


=IF(cond1, if(cond2, showThisForTrueCond1Cond2, showThisForTrueCond1Cond2False), showThisForFalseCond1)

Hope this gives you enough idea to construct the if statements