TALLER DE INFORMATICA II

FORMULASSUBTOTAL 1 =D5*F5 SUBTOTAL 2 =E5*F5

DESCUENTO =SI(H5<=10000;H5*3%;SI(H5<=15000;H5*4%;SI(H5<=20000;H5*5%;SI(H5<= 25000;H5*6%;SI(H5>25000;H5*7%))))) IVA 12 % =(H5*$J$24) TOTAL A PAGAR =H5-I5+J5 MARCAS =CONTAR.SI(C5:C14;"OSTER") =CONTAR.SI(C5:C14;"INDURAMA") =CONTAR.SI(C5:C14;"SONY") =CONTAR.SI(C5:C14;"LG")