Basic Formulas in Excel
There are some of the important Excel formula as mentioned below:
1. Add: Use the plus sign (+) to add values from two or more cells.
- Example =A4+D5
2. Subtract: Use the minus sign (-) to subtract values from two or more cells.
- Example=A4-D5
3. Multiply: Use the asterisk () to multiply values from two or more cells.
- Example=A4*D5
4. Divide: Use the forward slash (/) to divide values from two or more cells.
- Example=A4/D5
5. DATE: Creates a date value based on specified year, month, and day.
- Example=DATE(2022, 3, 27)
6. IF: Performs a logical test and returns different values based on the test result.
- Example=IF(A1>B1, “Yes”, “No”)
7. AVERAGE: Calculates the average of values in a range.
- Example=AVERAGE(B1:B5)
8. VLOOKUP: Searches for a value in a table and returns a corresponding value from another column.
- Example=VLOOKUP(A2, Table1, 2, FALSE)
9. INDEX/MATCH: Retrieves a value from a specific row and column intersection in a table.
- Example=INDEX(Table1, MATCH(“Criteria”, Column1, 0), 3)
We can use parentheses to create complex formulas that combine these operations.
- Example: =((A4+C4)/(D5-C5)*3)
What is Excel?
Microsoft Excel is a powerful tool used by students, professionals, and beginners to organize, analyze, and present data. Its user-friendly design and wide range of features help in creating sheets, entering data, performing calculations, and visualizing information easily.
Contact Us