Previous Topic Next Topic

If formula with conditions for 3 statements

Closed
Carla - Jun 29, 2010 at 09:08 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 29, 2010 at 11:55 AM
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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 29, 2010 at 11:55 AM
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
0