FUNCIÓN CONDICIONAL (SI ANIDADA)

N° NOMINA NOTA 1

NOTA 2

NOTA 3

NOTA 4

PROMEDIO CONDICION EQUIVALENCIA REGALO PORCENTAJE

1 CARLOS FREIRE 10,0 9,0 3,0 6,0 7,0 APROBADO C 6,3 4,02 ALICIA RUEDA 4,0 7,0 4,0 1,0 3,5 REPROBADO E 1,0 4,03 JEAN ARMIJOS 8,0 8,0 8,0 4,0 7,0 APROBADO C 4,0 2,44 NICOLE GRANDA 9,0 10,0 9,0 10,0 9,5 APROBADO A 10,0 3,25 FREDDY ORTEGA 7,0 4,0 7,0 9,0 6,8 REPROBADO C 10,0 1,16 LIA GUERRERO 8,0 8,0 10,0 7,0 8,3 APROBADO B 7,5 2,47 MARLENE GALARZA 4,0 9,0 4,0 4,0 5,3 REPROBADO D 4,0 4,08 JORGE GARCIA 8,0 7,0 8,0 8,0 7,8 APROBADO C 8,8 2,49 JHON PECIADO 9,0 6,0 9,0 9,0 8,3 APROBADO B 10,0 3,2

10 FLOR PALACIOS 7,0 3,0 7,0 7,0 6,0 REPROBADO D 7,5 1,1TOTAL 74,0 71,0 69,0 65,0 68,3PROMEDIO 7,4 7,1 6,9 6,5 6,8

=PROMEDIO(C2:F2)

=SI(G2>=7;"APROBADO";"REPROBADO")

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

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

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

=SUMA(C2:C11)

=PROMEDIO(C2:C11)