Arithmetic operations in Excel

Arithmetic operations in Excel are simple calculations performed using mathematical operators. Here’s a quick guide on how to use them:

---

1. Operators in Excel:

• Addition: +
• Subtraction: -
• Multiplication: *
• Division: /
• Exponentiation: ^

---

2. How to Perform Arithmetic Operations:

Example Data Setup:

A	B
10	5

• Cell A1 contains 10, and B1 contains 5.

Basic Formulas:

1. Addition:
   • Formula: =A1 + B1
   • Result: 15
2. Subtraction:
   • Formula: =A1 - B1
   • Result: 5
3. Multiplication:
   • Formula: =A1 * B1
   • Result: 50
4. Division:
   • Formula: =A1 / B1
   • Result: 2
5. Exponentiation (Power):
   • Formula: =A1 ^ B1
   • Result: 10^5 = 100000

---

3. Steps to Perform Arithmetic Operations in Excel:

1. Select the cell where you want the result.
2. Type the = sign to begin the formula.
3. Use cell references (like A1 and B1) or numbers in the formula.
4. Press Enter to see the result.

---

4. Mixed Operations:

Excel follows the Order of Operations (PEMDAS):

1. Parentheses
2. Exponents
3. Multiplication and Division (from left to right)
4. Addition and Subtraction (from left to right)

Example:

• Formula: =(A1 + B1) * 2
• Calculation: (10 + 5) * 2 = 30

---