SEMANA ONCE

1.-

E7=SI(D7="A","premiun",SI(D7="B","dorada",SI(D7="C","plateada")))
G7=F7*0.19
H7=SI(F7+G7>=130,"habilitado","inhabilitado")
E20=BUSCARV(E19,A7:H16,2,0)

2.-

B16=SUMA(B7:B15)

H7=SUMA(B7:G7)

F25=SUMA(D12:E12,D14:E14)

F28=SUMA(B10:B11,E10:E11,H12)

F32=PROMEDIO(B7:G7)

F35=PROMEDIO(E13:G13,E15:G15)

F40=PROMEDIO(C7:C15)

F45=SUMA(B8:D9)

F48=SUMA(E12:G12,B13:D13)

F53=SUMA(H7,H9,H11)

3.-