ݺߣ

ݺߣShare a Scribd company logo
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"))))

More Related Content