Formulas- Predefined functions are called formulas. Formula makes our work easier. Every formula always begins with equal sign (=).
There are following basic formulas in MS Excel-
1. SUM( )- This formula is used to add numbers.
Ex 1- =sum(5,10,26,30)
71
Ex 2- =sum(A1,A2,A3,A4) or =sum(A1:A4)
It will display the sum of cells A1:A4
2. Average( )- This function is used to find the average of numbers.
Ex. =Average(12,18,3)
11
3. Max( )- This function returns maximum value within a range.
Ex. =Max(27,38,45,6)
38
4. Min( )- This function returns minimum value within a range.
Ex. =Min(27,38,45,6)
6
5. Count( )- This function counts value within a range.
Ex- =Count(5,12,17,22)
4
6. Countif( )- This function counts value within a range based on a given criteria.
Watch video by clicking on this -
👇👇👇👇👇👇👇👇👇
