I'm looking to use a formula based on a set of rules.
For example, IF B2 = "F" AND the value in D2 lies between 121 and 141 then it will report "D"
I have multiple grade boundaries based on whether students have taken a F - Foundation paper or H - Higher paper exam?
Any help as ever greatly appreciated.
Soggy40
For example, IF B2 = "F" AND the value in D2 lies between 121 and 141 then it will report "D"
I have multiple grade boundaries based on whether students have taken a F - Foundation paper or H - Higher paper exam?
Any help as ever greatly appreciated.
Soggy40