Taller 2
3
TALLER Nº 2 *(FUNCION SI) *(FUNCION SUMA) *(FUNCION MAX – MIN - PROMEDIO)
-
Upload
pakiita-serrano -
Category
Documents
-
view
11 -
download
0
Transcript of Taller 2
![Page 1: Taller 2](https://reader035.fdocuments.co/reader035/viewer/2022071901/55c110fcbb61eb6b188b462b/html5/thumbnails/1.jpg)
TALLER Nº 2*(FUNCION SI) *(FUNCION SUMA)
*(FUNCION MAX – MIN - PROMEDIO)
![Page 2: Taller 2](https://reader035.fdocuments.co/reader035/viewer/2022071901/55c110fcbb61eb6b188b462b/html5/thumbnails/2.jpg)
DESARROLLO (FORMULAS)• DESCUENTO 1
=SI(C3="VOLVO";F3*5%;F3*3%)
• DESCUENTO 2=SI(D3="VERDE";F3*1,5%;F3*1%)
• DESCUENTO 3=SI(B3>=85;F3*2,5%;F3*2,8%)
• PAGO TOTAL=(F3-G3-H3-I3)
![Page 3: Taller 2](https://reader035.fdocuments.co/reader035/viewer/2022071901/55c110fcbb61eb6b188b462b/html5/thumbnails/3.jpg)
DESARROLLO (FORMULAS)• TOTALES
=SUMA(F3:F7)
• MAX=MAX(F3:F7)
• MIN=MIN(F3:F7)
• PROMEDIO=PROMEDIO(F3:F7)