Why the Order of Your NESTED IF THEN ELSE formula is important
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