Mathematical Formula
Basic Excel Mathematical Formulas
1. Addition
=A1+B1
Adds the values in cells A1 and B1.
2. Subtraction
=A1-B1
Subtracts the value in B1 from A1.
3. Multiplication
=A1*B1
Multiplies the two cell values.
4. Division
=A1/B1
Divides A1 by B1. Ensure that B1 is not zero.
5. Total
=SUM(A1:A10)
Adds the numeric values in cells A1 through A10.
6. Average
=AVERAGE(A1:A10)
Calculates the arithmetic mean of the numeric values in the selected range.
7. Percentage
=A1*B1/100
Calculates B1 percent of the value in A1. For example, if A1 is 500 and B1 is 10, the result is 50.
8. Commission
=B2*C2/100
Calculates commission when B2 contains the sales amount and C2 contains the commission rate as a whole percentage. For sales of 10,000 and a rate of 5, the commission is 500.
9. Conditional Result
=IF(A1>=50,"Pass","Fail")
Returns Pass if A1 is at least 50; otherwise, it returns Fail.
10. Lookup
=XLOOKUP(E2,A2:A10,B2:B10,"Not Found")
Searches for the value in E2 within A2:A10 and returns the corresponding value from B2:B10. XLOOKUP requires a compatible Excel version.
Step-by-Step Worked Example
### Example: Calculate Total Sales in Excel
Suppose you have the following sales data in an Excel worksheet:
| Product | Sales |
|---|---:|
| Product A | 100 |
| Product B | 200 |
| Product C | 150 |
| **Total** | **450** |
**Step 1:** Enter your sales values into cells B2, B3, and B4.
**Step 2:** Select cell B5, where you want the total to appear.
**Step 3:** Enter the following formula:
`=SUM(B2:B4)`
**Step 4:** Press Enter.
**Result:** Excel calculates the total sales as **450**.
**Explanation:** The SUM function adds all numeric values within the selected range. In this example, it adds 100, 200, and 150 to produce 450.
You can use the Excel Formula Finder to search for SUM and discover its syntax, purpose, and other practical examples.
Important Considerations & Limitations
- Excel formulas may work differently depending on your Excel version and spreadsheet software.
- Some formulas, such as XLOOKUP, are not available in older Excel versions.
- Formula results depend on the accuracy and format of your input data.
- Incorrect cell references, missing values, or typing errors can lead to unexpected results.
- Some formulas require specific arguments, ranges, or conditions to work correctly.
- Excel uses different list separators, such as commas or semicolons, depending on regional settings.
- Always verify important calculations before using them in business reports, financial records, or other critical tasks.
- The Excel Formula Finder helps you discover formulas and understand their usage, but it does not replace checking your actual spreadsheet data.
Continue your workflow with these verified calculators and utilities: