Is there a way to utilize multiple IF statements in the gradebook calculations? I have a scale set up that should give a result based on the students mark but I am having two issues:
1. I don't want it to calculate the result unless a mark has actually been entered in the other column (so it only applies to students that have taken the test)
2. The scale is set up to be Successful (80-100), Project (75 - 80), or Rewrite (Below 75) depending on the mark.
Any help would be appreciated.
Gradebook
Multiple IF statements
This discussion has been locked so you can no longer reply to it.