Peligro Unidad 3 Lección 2. FUTURO CONDICIONAL VOCABULARIO FUTURO VS. CONDICIONAL.
Funcíon condicional
-
Upload
lizbeth-calderon -
Category
Education
-
view
18 -
download
0
Transcript of Funcíon condicional
![Page 1: Funcíon condicional](https://reader036.fdocuments.co/reader036/viewer/2022071923/55d166d6bb61eb2d338b475d/html5/thumbnails/1.jpg)
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)