What are the formulas of excel?

 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 < 10)

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

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:

18. AVERAGEIF: Calculates the average of a range based on a specified condition. Example: =AVERAGEIF(H1:H20, ">50")

19. COUNTIF: Counts the number of cells in a range that meet a specific condition. Example: =COUNTIF(I1:I30, "<=100")

20. SUMIF: Adds up the values in a range that meet a specific condition. Example: =SUMIF(J1:J40, "Apples", K1:K40)

These are just a few examples of the many formulas available in Excel. To use a formula, enter it in a cell preceded by an equal sign (=), and Excel will perform the calculation based on the formula's logic and the data in the specified cells. You can also explore more advanced formulas and functions for more complex calculations and data analysis.

About News & updates

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.