Many newbies get confused by the NESTED-IF-THEN-ELSE (NITE) formula. This lecture explains how the NITE formula works and should help you avoid common pitfalls.

Nested If Then Else Tips

• The NITE formula is executed from the first condition (on the top line) all the way down to the final ELSE statement.
• As soon as SIMS finds a matching (true) condition, all further conditions are ignored.
• I usually make the first condition the highest value (eg IF MathScore > 90 then A*) and work my way down to the lowest score (eg ELSE IF MathsScore < 10 then U)

Still Confused?

Ask me a qustion via the comments below