FUNCIONES

Embed Size (px)

DESCRIPTION

excel

Citation preview

Formulas

ESTUDIANTESENEROFEBREROMARZOTOTAL TRIMESTRESEM 1SEM 2SEM 3SEM 4SEM 1SEM 2SEM 3SEM 4SEM 1SEM 2SEM 3SEM 4ANA SANDOVAL$ 2,500$ 3,000$ 4,500$ 2,000$ 4,500$ 3,200$ 3,700$ 4,000$ 2,000$ 2,000$ 3,500$ 5,000$ 39,900ANDRES CASTRO$ 3,000$ 2,000$ 3,000$ 3,000$ 2,800$ 2,000$ 2,000$ 3,500$ 2,000$ 4,500$ 2,000$ 2,000$ 31,800CARLOS BENAVIDES$ 2,500$ 3,000$ 3,000$ 3,000$ 4,500$ 5,000$ 3,000$ 4,500$ 2,800$ 2,000$ 4,500$ 3,500$ 41,300DIANA CHAVEZ$ 3,500$ 5,000$ 3,000$ 3,500$ 2,000$ 2,800$ 2,000$ 3,000$ 5,000$ 2,500$ 2,800$ 3,000$ 38,100BIBIANA LOPEZ$ 4,500$ 2,800$ 5,000$ 3,000$ 3,000$ 3,000$ 3,500$ 4,500$ 4,500$ 2,000$ 3,000$ 4,500$ 43,300LUIS MORALES$ 5,000$ 3,500$ 4,500$ 2,800$ 3,000$ 4,500$ 3,000$ 2,800$ 3,000$ 3,500$ 4,500$ 2,000$ 42,100MARCELA DIAZ$ 3,500$ 2,000$ 5,000$ 2,000$ 5,000$ 2,500$ 2,000$ 5,000$ 3,000$ 2,000$ 2,800$ 3,000$ 37,800JEFERSON TIMANA$ 3,000$ 4,500$ 3,000$ 4,500$ 5,000$ 2,000$ 4,500$ 5,000$ 4,500$ 2,500$ 2,000$ 2,500$ 43,000ERLY ACOSTA$ 2,800$ 2,800$ 3,000$ 2,500$ 3,000$ 3,500$ 2,000$ 2,500$ 3,500$ 2,800$ 2,000$ 3,000$ 33,400CAMILO RESTREPO$ 4,000$ 4,500$ 3,500$ 2,000$ 3,000$ 3,000$ 4,500$ 2,000$ 2,000$ 3,000$ 2,000$ 4,500$ 38,000TOTAL$ 34,300$ 33,100$ 37,500$ 28,300$ 35,800$ 31,500$ 30,200$ 36,800$ 32,300$ 26,800$ 29,100$ 33,000$ 388,700

MAXIMO AHORRO$ 31,800MINIMO AHORRO$ 43,300PROMEDIO ENERO$ 33,300PROMEDIO FEBRERO$ 33,575PROMEDIO MARZO$ 30,300PROMEDIO TOTAL$ 32,392