Ms Excel

some useful formulas of Ms Excel

1. SUM: Adds up all the numbers in a range. Example: =SUM(A1:A10) adds up the numbers in cells A1 through A10.
2. AVERAGE: Calculates the average of numbers in a range. Example: =AVERAGE(B1:B5) calculates the average of numbers in cells B1 through B5.
3. MAX: Returns the largest number in a range. Example: =MAX(C1:C10) returns the largest number in cells C1 through C10.
4. MIN: Returns the smallest number in a range. Example: =MIN(D1:D8) returns the smallest number in cells D1 through D8.
5. COUNT: Counts the number of cells that contain numbers in a range. Example: =COUNT(E1:E20) counts how many cells in cells E1 through E20 contain numbers.
6. IF: Performs a logical test and returns one value if the condition is TRUE and another value if it’s FALSE. Example: =IF(A1>10, "Yes", "No") checks if the value in cell A1 is greater than 10. If true, it returns “Yes”, otherwise “No”.
7. VLOOKUP: Searches for a value in the first column of a table array and returns a value in the same row from another column. Example: =VLOOKUP(F1, A1:B10, 2, FALSE) searches for the value in cell F1 in the range A1:B10 and returns the corresponding value from the second column.
8. HLOOKUP: Similar to VLOOKUP, but searches horizontally across rows. Example: =HLOOKUP(G1, A1:F5, 3, FALSE) searches for the value in cell G1 in the range A1:F5 and returns the corresponding value from the third row.
9. CONCATENATE: Joins two or more text strings into one string. Example: =CONCATENATE("Hello", " ", "World") combines the text strings “Hello”, a space, and “World” into “Hello World”.
10. LEN: Returns the number of characters in a text string. Example: =LEN(A1) returns the number of characters in the text string in cell A1.

These are just a few examples of Excel formulas. Excel offers many more functions and capabilities for performing a wide range of calculations and data manipulations

Please follow and like us: