Mastering Arithmetic Operations in Excel

Excel isn’t just for data storage—it’s a powerful calculator! 💡 Whether you’re calculating totals, averages, or percentages, mastering basic arithmetic operations is essential.

In this guide, we’ll break down how to use:
✅ Addition (+)
✅ Subtraction (-)
✅ Multiplication (*)
✅ Division (/)
…and some bonus Excel tricks to speed up your calculations! 🎯

📌 No need for a calculator anymore—Excel does the math for you!

---

🖥️ How to Perform Arithmetic Operations in Excel?

In Excel, all formulas start with an equals sign (=). This tells Excel to perform a calculation instead of treating the entry as text.

➕ 1. Addition in Excel (+)

Formula:
👉 =Number1 + Number2

Example:
To add 10 and 20, type this in a cell:
=10 + 20
🔹 Press Enter – Excel will display 30 🎉

📌 Real-World Example: Adding sales values:
If A1 = 1000 and B1 = 500, enter:
👉 =A1 + B1 → 1500

🎥 Watch this tutorial on Addition in Excel:
🔗 Excel Addition Guide

---

➖ 2. Subtraction in Excel (-)

Formula:
👉 =Number1 – Number2

Example:
To subtract 50 from 100, type:
=100 – 50
🔹 Press Enter – Excel will show 50 ✅

📌 Real-World Example: Calculating profit:
If Total Revenue (A2) = $5000 and Expenses (B2) = $3000, enter:
👉 =A2 – B2 → $2000 (Profit)

🎥 Watch how to subtract in Excel:
🔗 Excel Subtraction Guide

---

✖️ 3. Multiplication in Excel (*)

Formula:
👉 =Number1 * Number2

Example:
To multiply 8 by 5, type:
=8 * 5
🔹 Press Enter – Excel returns 40 ✅

📌 Real-World Example: Calculating total cost:
If A3 = 10 (items) and B3 = 25 (price per item), enter:
👉 =A3 * B3 → 250 (Total Cost)

🎥 Watch Multiplication in Excel:
🔗 Excel Multiplication Guide

---

➗ 4. Division in Excel (/)

Formula:
👉 =Number1 / Number2

Example:
To divide 100 by 5, type:
=100 / 5
🔹 Press Enter – Excel shows 20 ✅

📌 Real-World Example: Finding the price per unit:
If Total Bill (A4) = $200 and No. of People (B4) = 4, enter:
👉 =A4 / B4 → $50 per person

🎥 Watch Division in Excel:
🔗 Excel Division Guide

---

🎁 Bonus: Quick AutoSum Trick for Addition!

Instead of manually typing formulas, use AutoSum (Σ) for quick calculations!

✅ How to use AutoSum?

1️⃣ Click on the cell below the numbers you want to add
2️⃣ Press Alt + = (or click AutoSum Σ in the toolbar)
3️⃣ Press Enter – Excel adds everything instantly! 🎉

🎥 See AutoSum in action:
🔗 AutoSum in Excel

---

🚀 Final Thoughts

Mastering basic arithmetic in Excel will save you tons of time ⏳ and make number-crunching a breeze! 🎯

📌 Next Steps:
🔹 Want to learn Excel formulas? Check out this guide
🔹 Need help with percentage calculations? Watch this video

📢 What Excel formula do you use most often? Drop a comment below! 💬👇