Grade Formula Required

[Rushendra]

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

[shukla.ankur281190]

Try
E23

=LOOKUP(E20,{0,"Below Average";7,"Average";11,"Good"})

[JohnTopley]

In E4

=IFERROR(VLOOKUP($C4,$H$6:$I$8,2,0),"")

Copy down

in E23

=IF($E$20<7,"Below Average",IF($E$20<=10,"Average","Good"))

[sandy666]

or
E3:E20: =IFERROR(CHOOSE(MATCH(C3,{"Correct","Incorrect","Not Performed"},0),1,0,-1),"")
E23: =IFERROR(CHOOSE(MATCH(E20,{0,7,11,99},1),"Below Average","Average","Good"),"")

and you don't need definition tables