A formula is an expression which calculates the value of a cell. These are predefined formulas and are already available in Excel. The most used formulas are,
Sum : It'll do the sum of selected cells. The formula is " =sum(number1,number2,...) ", we can also select whole cells by dragging.
Average : It'll do the average of selected cells. The formula is " =Average(number1,number2,...) ".
Count : Count will count only numbers not characters. The formula is " =Count(number1,number2,...) ".
Counta : Counta wil count non empty cells including text. The formula is " =Counta(number1,number2,...) ".
Concatenate : It'll concatenate the selected cells. The formula is " =Concatenate(number1,number2,...) ".
If : It is a logical formula, which test a condition is met and returns one value if true, and other value is false. The formula is " =if(logical test,[value if true],[value if false]) ".
Countif : Countif will count the cells which are repeated. The formula is " =countif(range,criteria) ".
- Sum
- Average
- Count
- Counta
- Concatenate
- If
- Countif
Sum : It'll do the sum of selected cells. The formula is " =sum(number1,number2,...) ", we can also select whole cells by dragging.
Average : It'll do the average of selected cells. The formula is " =Average(number1,number2,...) ".
Count : Count will count only numbers not characters. The formula is " =Count(number1,number2,...) ".
Counta : Counta wil count non empty cells including text. The formula is " =Counta(number1,number2,...) ".
Concatenate : It'll concatenate the selected cells. The formula is " =Concatenate(number1,number2,...) ".
If : It is a logical formula, which test a condition is met and returns one value if true, and other value is false. The formula is " =if(logical test,[value if true],[value if false]) ".
Countif : Countif will count the cells which are repeated. The formula is " =countif(range,criteria) ".