Here are 10 common formulas in Microsoft Excel that are essential for various tasks:

Here are 10 common formulas in Microsoft Excel that are essential for various tasks:

1. SUM: Adds up a range of numbers.

   • =SUM(A1:A10) – Adds the values from cells A1 to A10.

2. AVERAGE: Calculates the average of a range of numbers.

   • =AVERAGE(B1:B10) – Returns the average of the values in cells B1 to B10.

3. IF: Performs a logical test and returns one value for TRUE and another for FALSE.

   • =IF(C1>50, "Pass", "Fail") – Checks if the value in C1 is greater than 50.

4. VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from another column.

   • =VLOOKUP(D1, A1:B10, 2, FALSE) – Looks for the value in D1 in the first column of A1
     and returns the corresponding value from the second column.

5. INDEX: Returns the value of a cell at a specified row and column within a range.

   • =INDEX(A1:B10, 3, 2) – Returns the value in the 3rd row and 2nd column of the A1
     range.

6. MATCH: Searches for a specified value in a range and returns the relative position.

   • =MATCH(E1, A1:A10, 0) – Finds the position of the value in E1 within the A1
     range.

7. CONCATENATE (or &): Combines multiple text strings into one.

   • =CONCATENATE(F1, " ", G1) or =F1 & " " & G1 – Joins the text in F1 and G1 with a space in between.

8. COUNTIF: Counts the number of cells that meet a condition.

   • =COUNTIF(H1:H10, ">50") – Counts the cells in H1
     that have values greater than 50.

9. LEFT/RIGHT: Extracts a specified number of characters from the left/right of a text string.

   • =LEFT(I1, 5) – Extracts the first 5 characters from the text in I1.
   • =RIGHT(I1, 3) – Extracts the last 3 characters from the text in I1.

10. LEN: Returns the number of characters in a text string.

    • =LEN(J1) – Counts the number of characters in cell J1.

These formulas cover a range of basic to intermediate Excel functionalities and are useful for various purposes like data analysis, conditional checks, and text manipulation