I tried to do this and failed. It is supposed to assign SATS levels from mark scores.
Apparently a max of 7 "nests" is available???????
=IF(H2>130,"7a",IF(H2>109,"7b",IF(H2>86,"7c",IF(H2>75,"6a",IF(H2>64,"6b",IF(H2>53,"6c",IF(H2>46,"5a",IF(H2>38,"5b",IF(H2>31,"5c",IF(H2>25,"4a","N"))))))))))
Don't tell me I need to buy "Excel for Dummies" I know that already!!!!
Rob
143 views
Usually answered in minutes!
Very useful advise thank you!
×