Decima primera semana

Practica 1: =SI(D7="A", "premium", SI(D7="B", "dorada", SI(D7="c", "plateada", " "))) =(F7*19%) =SI(F7+G7>=130, "habilitado", "inhabilitado") Practica 2: =SUMA(B7:G7) =SUMA(H7:H15) =PROMEDIO(B7:G7) =PROMEDIO(E13:G13, E15:G15) Practica 3: =C8*$F$5 =D8*E8 =SUMA(F8:F15) =(F17*60%) Practica 4: =CONTAR.SI($D$6:$D$15, G11) =SUMAR.SI($D$6:$D$15, G11, $E$6:$E$15) =CONTAR(E6:E15) =CONTAR.BLANCO(E6:E15) =MAX(E6:E15) =MIN(E6:E15) Practica 5: =PROMEDIO(E5:E14) =SI(L5+M5>=40, "orientado", "desorientado") =CONTAR(E5:E14) =CONTAR.SI($N$5:$N$14, N6) Practica 6: =BUSCARV(B12, E6:H10, 2, 0) =BUSCARV(A16, A6:C10, 2, 0) =BUSCARV(A16, A6:C10, 3, 0) =SUMA(F21:F22) =(F21*19%) =(C16*10%) Practica 7: =SI(C6="A1", "contabilidad", SI(C6="A2", "ventas", SI(C6="A3", "finanzas", SI(C6="A4", "mercadotcnia", " ")))) =SI(E6="A", 2600, SI(E6="B", 2400, SI(E6="C", 1500, SI(E6="D", 1000)))) =SI(E6="A", F6*2%, SI(E6="B", F6*2.5%, SI(E6="C", F6*3%, SI(E6="D", F6*3.5%)))) =SI(G6<=3, F6*0.75%, SI(G6>=4, F6*1.2%)) Practica 8: =SI(E5="contador", "A", SI(E5="auxiliar", "B", SI(E5="obrero", "C", " "))) =SI(F5="A", 1500, SI(F5="B", 1000, SI(F5="C", 800))) =SI(D5<=2, G5*5%, SI(D5>=3, G5*10%)) =E20*19% =SUMA(G5+H5+I5) =CONTAR.SI($E$5:$E$14, E5) =SUMA(H36:I36) =CONTAR.SI(C5:C14, C9) Practica 9: =E29*G10 =D15*30 =SUMA(E15:E19) =SI(C5="casado", G5*10%, SI(C5="soltero", G5*5%, SI(C5="viudo", G5*12%)))