Wednesday, September 26, 2012

This blog is designed for present the most useful funtion in "Microsoft Excel" if you have any doubts or you want to add some funtions that I will not include, you are totally free to do it.

contar: It is use to count the number of cells you select than have numbers.
contar.si: It is use to count the cells that match with the condition given.
contara: It is use to count the cell in a range that have data on it.
contar.si.conjunto: It is use to count a number of cells that accomplish an  deteminate set of conditions.
sumar: Adds all the numbers in a range of cells.
sumar.si: add cells that accomplish certain criteria or condition.
sumar.si.conjunto: add cells that accomplish certain sets of criteria or conditions.
promedio: returns the average of the arguments, which can be numbers, names, arrays, or references that contain numbers.
promedio.si: finds the average of the cells that accomplish certain criteria or condition.
promedio.si.conjunto: finds the average of the cells that accomplish certain sets of criteria or condition.
si: It is use to check  if a condition is met and returns a value if it evaluates to TRUE and another value if it                  evaluates to FALSE.
no: It is to change FALSE for TRUE or TRUE for FALSE .
y: checks if all arguments are true, and returns true if all arguments are true.
o : It checks if all arguments are true, and returns true or false, and it returns false if all arguments are false.
max: Returns the maximum value of a list of values​​, ignores logical values ​​and text. min: Returns the minimum value from a list of values​​, ignores logical values ​​and text.