Download - Taller de informatica. i1
Transcript
![Page 1: Taller de informatica. i1](https://reader036.vdocumento.com/reader036/viewer/2022082609/55d1c509bb61ebfd468b4634/html5/thumbnails/1.jpg)
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")