📊 Excel Basics #9 – Your First Formula in Excel

Formulas are the heart of Excel. They allow you to perform calculations automatically instead of doing them manually.

📌 What is a Formula? 
A formula is an expression that tells Excel to calculate a result. 
Every formula in Excel must start with an equal sign "=".

Example: 
"=10+20" 
Result: 30

📌 Using Cell References 
Instead of typing numbers directly, you can refer to cells.

Example: 
A2: 100 
B2: 50 
C2: "=A2+B2" 
Result in C2: 150

If you change A2 from 100 to 200, the result automatically updates to 250. 

This is why using cell references is better than typing values directly.

📌 Basic Arithmetic Operators 
Excel supports the following operators: 
• "+" → Addition
• "-" → Subtraction
• "_" → Multiplication
• "/" → Division
• "^" → Power (Exponent)

Examples: 
• "=A2+B2" → Add values
• "=A2-B2" → Subtract values
• "=A2B2" → Multiply values
• "=A2/B2" → Divide values
• "=A2²" → Square the value in A2

📌 Order of Operations 
Excel follows the standard mathematical order: 
1. Parentheses "()"
2. Exponents "^"
3. Multiplication & Division "_" "/"
4. Addition & Subtraction "+" "-"

Example: 
"=10+5₂" 
Result: 20 

Because multiplication is performed first.

To change the order: 
"=(10+5)₂" 
Result: 30

💡 Real-World Example 
Product: Laptop 
Price B2: 50000 
Quantity C2: 2 
Total D2: "=B2C2" 

Result: 100000

Whenever the Price or Quantity changes, the Total updates automatically.

✅ Best Practices 
• Always start formulas with "=".
• Use cell references instead of hardcoding values.
• Use parentheses for complex calculations.
• Double-check formulas before copying them to other cells.

Mastering formulas is the first step toward becoming an Excel expert.

Double Tap ❤️ For More