Dear Team, Help me with the formula for the Marks column - E based on feedback selcted in Column - C
and based on Total marks required Grade also to be updated in Grade
PFA attached document.
below are the feedback & Grade Criteria,
IF feedback = Correct = 1
IF feedback = incorrect = 0
IF feedback = Not performed = -1
Grade
IF Total = Below 7 = Below Average
IF Total = Between 7 to 10 = Below Average
IF Total = Between 11 to 14 = Good
Regards
Rush
Bookmarks