FORMULAS DE EXCEL
Suma
=suma (b2:b4)
= (b2+b3+b4)
Promedio
= (b2+b3+b4)/3
=promedio(b2:b3)
Porcentaje
= b2*21%
Total
a pagar – descuento
=b2-(b2*21%)
Formulas
lógicas
=si (¿?; v:f)
=si (a2>3; b2*5%;b2*15%)
=si(b2>=51;"aprobado";"reprobado")
FORMULA LOGICA
FORMULA LOGICA
