100 Nos Of Formula and Functions
In MSExcel
Part 1
1-20: Basic Mathematical Functions
1. SUM - Adds up a range of numbers.
o Example: =SUM(A1:A10)
For Detail --->Click here
2. AVERAGE - Calculates the average of a range of numbers.
o Example: =AVERAGE(B1:B10)
For Detail --->Click here
3. MIN - Finds the smallest number in a range.
o Example: =MIN(C1:C10)
For Detail --->Click here
4. MAX - Finds the largest number in a range.
o Example: =MAX(D1:D10)
For Detail --->Click here
5. COUNT - Counts the number of cells with numbers in a range.
o Example: =COUNT(E1:E10)
For Detail --->Click here
6. COUNTA - Counts non-empty cells.
o Example: =COUNTA(F1:F10)
For Detail --->Click here
7. COUNTIF - Counts cells that meet a specific condition.
o Example: =COUNTIF(G1:G10, ">10")
For Detail --->Click here
8. SUMIF - Adds cells based on a condition.
o Example: =SUMIF(H1:H10, ">5")
For Detail --->Click here
9. SUMIFS - Adds cells based on multiple conditions.
o Example: =SUMIFS(I1:I10, J1:J10, ">5", K1:K10, "<20")
For Detail --->Click here
10. ROUND - Rounds a number to a specified number of digits.
o Example: =ROUND(L1, 2)
For Detail --->Click here
11. ROUNDUP - Rounds a number up.
o Example: =ROUNDUP(M1, 0)
For Detail --->Click here
12. ROUNDDOWN - Rounds a number down.
o Example: =ROUNDDOWN(N1, 1)
For Detail --->Click here
13. INT - Rounds a number down to the nearest integer.
o Example: =INT(O1)
For Detail --->Click here
14. MOD - Returns the remainder of a division.
o Example: =MOD(P1, 3)
For Detail --->Click here
15. PRODUCT - Multiplies a range of numbers.
o Example: =PRODUCT(Q1:Q10)
For Detail --->Click here
16. POWER - Raises a number to a power.
o Example: =POWER(R1, 2)
For Detail --->Click here
17. SQRT - Calculates the square root.
o Example: =SQRT(S1)
For Detail --->Click here
18. EXP - Returns e raised to a power.
o Example: =EXP(T1)
For Detail --->Click here
19. ABS - Returns the absolute value.
o Example: =ABS(U1)
For Detail --->Click here
20. RAND - Generates a random number between 0 and 1.
o Example: =RAND()
For Detail --->Click here
