What are the Formulas of excel?

Microsoft Excel offers a wide range of formulas that allow you to perform various calculations, manipulate data, and automate tasks. Here are some commonly used Excel formulas grouped by their categories:

Basic Formulas:

1. SUM: Adds up numbers in a range. Example: =SUM(A1:A10)

2. AVERAGE: Calculates the average of numbers in a range. Example: =AVERAGE(B1:B20)

3. MIN: Finds the minimum value in a range. Example: =MIN(C1:C15)

4. MAX: Finds the maximum value in a range. Example: =MAX(D1:D25)

5. COUNT: Counts the number of cells with numeric values in a range. Example: =COUNT(E1:E30)

Text Formulas:

6. CONCATENATE: Combines text strings. Example: =CONCATENATE("Hello, ", A1)

7. LEFT: Extracts a specified number of characters from the beginning of a text string. Example: =LEFT(A2, 5)

8. RIGHT: Extracts a specified number of characters from the end of a text string. Example: =RIGHT(B2, 3)

9. LEN: Returns the length (number of characters) of a text string. Example: =LEN(C2)

Date and Time Formulas:

10. TODAY: Returns the current date. Example: =TODAY()

11. NOW: Returns the current date and time. Example: =NOW()

12. DATEDIF: Calculates the difference between two dates in years, months, or days. Example: =DATEDIF(D2, D3, "d")

Logical Formulas:

13. IF: Performs a logical test and returns different values based on the result. Example: =IF(A1 > 10, "Greater", "Less or Equal")

14. AND: Returns TRUE if all specified conditions are TRUE. Example: =AND(B1 > 5, C1

15. OR: Returns TRUE if at least one of the specified conditions is TRUE. Example: =OR(D1 > 100, E1

Mathematical Formulas:

16. SQRT: Calculates the square root of a number. Example: =SQRT(F1)

17. POWER: Raises a number to a specified power. Example: =POWER(G1, 3)

Statistical Formulas: