documentos de excel

                 DOCUMENTO DE EXCEL 

documento 1

B8*C8*D8

B8*2*D8+150

E8*35%

E8-F8-G8

E8+E9+E10+E11+E12+E13

PROMEDIO (E8:E13)

documento 2 

=C10*2

=C10/15

=E10/8

=C10*5%

=Si(G10=0,250,0)

=C10+F10*H10-E10*G10-I10

=SUMA(K10:K14)

=PROMEDIO(K10:K14)

=MAX(K10:K14)

=MIN(K10:K14)

Documento 3

               =C8+D8+E8

=F8*3%

=D8*2.5%

=F8+G8+H8+J8

=J8+J8*K8

=J8+J8*M8

Documento 4 

=PROMEDIO(C6:D6:E6)

=SI(F6>=6,"APROBO","REPROBO")

=SI(F6>8,500,0)

=SI(F6=10,1000+H6,H6)

=PROMEDIO(F6,F7,F8,F9,F10)

=PROMEDIO(C6,C7,C8,C9,C10)

=SUMA(H6:H10)

CONTAR.SI(H6:H10)

=MAX(F6:F10)

=MIN(F6:F10)

=CONTAR.SI(F6:F10,">8")

=SI(F11>8,"BUENO","MALO")

Documentos 5

=BUSCARV(H5,G13:I28,2)

=BUSCARV(H5,G13:J28,3)

=BUSCARV(H5,G13:J28;4)

Documento 6

 =SUMA(C7:E7)

=F7/$F$10

=SUMA(C7:C9)

=SUMA(C13:C15)

=SUMA(C10+C16)

Documento 6 HOJA 1

=HOJA1!C10

=HOJA1!C16

=HOJA1!C18

=HOJA1!F10

Documento 6 HOJA 2 

=HOJA2!F7

=HOJA2!F9

=SUMA(C8+C10)

Documento 7

=SUMA(B7:E7)

=B7*$B$5+C7*$C$5+D7*$D$5+E7*$E$5

=SI(F7>20000,500,0)

=G7+H7

=SUMA(B7:B16)

=PROMEDIO(B7:B16)

DOCUMENTO 8

=C11*E11

=F11/$F$15

=SUMA(E11:E14)

=F15

=F23

=32

=SUMA(A45:C45)

=PROMEDIO(A45:C45)

SI(D45>500,"X","")

=MAX(A45;C45)

=MIN(A45:C45)

Documento 9

                                                     =I7

=SI(E7=1,"DEPOSITO",SI(E7=2"RETIRO",SI(E7=3"DEVOLUCION","ERROR")))

=SI(E7=1,D7+G7,SI(E7=2,D7-G7,SI(E7=3,D7-H7"ERROR")))

=SI(E7=3,G7*20%,"")

DOCUMENTO 10

=SI([@CLAVE]="S19","PANTALONES",SI(["@CLAVE]="M12","BLUSA",SI([@CLAVE]="F28","VESTIDORES","ERROR")))

=SI([@CLAVE]="S19",30;SI([@CLAVE]="M12",15,SI([@CLAVE ]="F28",28,"ERROR")))

=[@[PRECIO UNITARIO]]*1.5

==[@[PRECIO DE VENTA]]*10%

=[@[PRECIO DE VENTA]]+[@IVA]

=[@[PRECIO VTA EN USD]]*$J$4

=[@CANTIDAD]*[@[PRECIO VTA EN USD]]

=[@CANTIDAD]*[@[IMPORTE VTA M,N]]

=SUMA(TABLA1[IMPORTE A PAGAR M.N])

=SUMA(TABLA1[IMPORTE A PAGAR USD2])

=MAX(TABLA1[IMPORTE A PAGAR M.N])

=CONTAR(TABLA1[TABLA1[CANTIDAD])

=SUMA(TABLA1[CANTIDAD])

=D4-F23