ma excel - formula

Excel formulas are used to perform calculations, manipulate data, and automate tasks in Microsoft Excel. Here are some commonly used formulas:

1. SUM: Adds up a range of cells.
Example: =SUM(A1:A10)

2. AVERAGE: Calculates the average of a range of cells.
Example: =AVERAGE(A1:A10)

3. MAX: Finds the maximum value in a range of cells.
Example: =MAX(A1:A10)

4. MIN: Finds the minimum value in a range of cells.
Example: =MIN(A1:A10)

5. COUNT: Counts the number of cells in a range that contain numbers.
Example: =COUNT(A1:A10)

6. IF: Checks whether a condition is true or false, and returns a value based on the result.
Example: =IF(A1>10,"Yes","No")

7. VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column.
Example: =VLOOKUP(A1,Table1,2,False)

8. CONCATENATE: Joins two or more text strings into one.
Example: =CONCATENATE(A1," ",B1)

9. DATE: Returns the date based on the year, month, and day values.
Example: =DATE(2021,10,31)

10. IFERROR: Checks whether a formula returns an error, and returns a value or message if it does.
Example: =IFERROR(A1/B1,"Error: Divide by zero")