For all these solutions Im using the following grade scale. The FALSE value is A meaning that if none of the criteria in the equation are met the student should be given an A. The Formula for Grade is the nested IF formula that checks certain criteria and returns the specific grade if the criteria is met.
The excel formula for percentage is Portion Days Total Days 100.
The FALSE value is A meaning that if none of the criteria in the equation are met the student should be given an A. The nested if is a long and time consuming formula to create but its relatively easy to understand. The Formula for Grade is the nested IF formula that checks certain criteria and returns the specific grade if the criteria is met. In the example shown key is the named range B5C9 the formula in F5.