Formulas

=PROMEDIO(C10:F10)

=SI(G10<7;"REPROBADO";"APROBADO")

=SI(G10<4;"E";SI(G10<=6;"D";SI(G10<=8;"C";SI(G10<=9;"B";"A"))))

=SI(F10=9;F10+1;SI(F10=8;F10+0,75;SI(F10=7;F10+0,5;SI(F10=6;F10+0,25;F10))))

=SI(C10=10;C10*40%;SI(C10=9;C10*35%;SI(C10=8;C10*30%;SI(C10=7;C10*15%;C10))))

=SUMA(C2:C11)

=PROMEDIO(C2:C11)

=SI(C10=10;C10*40%;SI(C10=9;C10*35%;SI(C10=8;C10*30%;SI(C10=7;C10*15%;C10))))

=SI(F10=9;F10+1;SI(F10=8;F10+0,75;SI(F10=7;F10+0,5;SI(F10=6;F10+0,25;F10))))

=SI(G10<4;"E";SI(G10<=6;"D";SI(G10<=8;"C";SI(G10<=9;"B";"A"))))