To perform addition and division in Excel, you can use simple formulas with the appropriate math operators.
Using Formulas for Addition and Division
Excel formulas always begin with an equals sign (=). After the equals sign, you enter the values and operators to perform your calculation.
Here's how to do addition and division:
Addition
-
Start with an equals sign (=).
-
Enter the values you want to add, separated by the plus sign (+).
Example:
=10+5
Division
-
Start with an equals sign (=).
-
Enter the values you want to divide, using the forward slash (/) as the division operator.
Example:
=10/5
Examples and Usage
Here's a table summarizing the operators and some examples:
| Operation | Operator | Example | Result |
|---|---|---|---|
| Addition | + |
=5+3 |
8 |
| Division | / |
=15/3 |
5 |
You can also use cell references in your formulas. For example, if cell A1 contains the value 10 and cell B1 contains the value 5:
=A1+B1would result in 15 (addition)=A1/B1would result in 2 (division)
Combining Addition and Division
You can combine both addition and division in a single formula. Excel follows the order of operations (PEMDAS/BODMAS), so division is performed before addition. If you need to change the order, use parentheses.
=10+20/5would result in 14 (20/5 = 4, then 10+4 = 14)=(10+20)/5would result in 6 (10+20 = 30, then 30/5 = 6)
Key Takeaways
- Always start with an equals sign (=).
- Use
+for addition and/for division. - You can use numbers directly in the formula, or cell references.
- Parentheses
()control the order of operations. - For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use — the plus sign (+) to add, and the forward slash (/) to divide.
