Excel Formulas to Be Productive

It is very important to be able to make formulas for our spreadsheet to do its work and give us the results we expect and not the wrong ones, since in formulas it has to be more complex the knowledge here some tricks to make them

nt
• If we want to add it with a formula that is very elementary, it is basic and very effective to do adding operations, this allows you to add a group of cells or even rows or entire columns the formula is: =SUMA (A1:A10), =SUMA(A: A), =SUMA (A1:Z10).

nt

• To be able to count this formula gives the ease of being able to count quantities of selected cells that have numbers, cells that do not contain numbers, that are empty or contain text instead of numbers are not taken into account, let us remember that many times in sheets there are many texts and we do not need them, the formula to count is: =CONT (A1:B10), =CONT(A: A).

nt

• This function is similar to the previous one but its name is Count this account but not only counts cells with numbers but also counts the text, its formula is: =CONTA ().

nt

• The following formula puts us with a CONTAR conditioning.If this formula allows us to count if they meet a condition nothing more and as an example we can put this: if the cells are equal to a certain value, or that are less than a certain value, or if they are equal to some value or some text that adds if not that does not, and its formula is =CONTAR.SI (“A1:B10”,”<0”).

nt

• This formula that we present below is called YES, this allows to have one value or another in the cell depending on a criterion, the conditions are similar to the previous one, we can give as an example that counts a list of notes of a student who is in a list, and if this is in the percentage of the average that says it is approved or rejected, its formula is: =SI (A1>0, “POSITIVE VALUE”, “negative VALOR”).

nt

• With this formula this allows BUSCARV, this what it does is to find a specific value in the same row for another column, you hear a little abstract this, but we will express it like this, if we have a list of students with their evaluation notes, and we want to know that note obtained “MARIO”, we can see that it obtained the third best evaluation, then to get that result we will occupy the following formula: =BUSCARV(“MARIO”, A1:Z100, 10, FALSO)

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,