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.
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)