Excel Basic Operators Explained: +, -, *, /, ^ with Practical Examples

Introduction

Microsoft Excel me calculation karne ke liye sabse pehle operators ko samajhna bahut zaroori hota hai. Operators wo symbols hote hain jo Excel ko batate hain ki numbers ke saath kaunsa operation karna hai. Agar aap Excel beginner hain, to +, -, *, /, aur ^ jaise basic operators aapke learning ka foundation hote hain. Ye operators almost har Excel formula me use hote hain. ---

What Are Excel Operators?

Excel operators symbols hote hain jo numbers, cells, ya values ke beech calculation perform karte hain. Jab bhi aap formula likhte hain, Excel operator ke bina calculation possible nahi hoti. Example: =10+5 Is formula me “+” ek operator hai. ---

Addition Operator (+)

Addition operator ka use numbers ko add karne ke liye hota hai.

Syntax

=A1 + B1

Example

A1 = 20 B1 = 30 Formula: = A1 + B1 Result: 50

Real-Life Use

Total marks, total salary, total expenses nikalne ke liye addition operator use hota hai. ---

Subtraction Operator (-)

Subtraction operator ka use ek value ko doosri value se minus karne ke liye hota hai.

Syntax

=A1 - B1

Example

A1 = 100 B1 = 40 Formula: = A1 - B1 Result: 60

Real-Life Use

Balance amount, remaining stock, ya discount calculate karne me subtraction ka use hota hai. ---

Multiplication Operator (*)

Multiplication operator ka use values ko multiply karne ke liye hota hai. Excel me multiply ke liye “*” sign use hota hai, not “×”.

Syntax

=A1 * B1

Example

A1 = 12 B1 = 5 Formula: = A1 * B1 Result: 60

Real-Life Use

Salary calculation, total cost (quantity × price), aur interest calculation me multiplication operator ka use hota hai. ---

Division Operator (/)

Division operator ka use ek number ko doosre number se divide karne ke liye hota hai.

Syntax

=A1 / B1

Example

A1 = 100 B1 = 4 Formula: = A1 / B1 Result: 25

Real-Life Use

Average, per-unit cost, aur marks percentage nikalne me division operator ka use hota hai. ---

Power Operator (^)

Power operator ka use kisi number ki power nikalne ke liye hota hai.

Syntax

=A1 ^ B1

Example

A1 = 2 B1 = 3 Formula: = A1 ^ B1 Result: 8 (2 × 2 × 2)

Real-Life Use

Mathematics calculations, compound interest, aur growth formulas me power operator use hota hai. ---

Operator Precedence in Excel

Excel me sab operators ek saath ho to Excel ek fixed order follow karta hai:

1. Power (^)
2. Multiplication (*) and Division (/)
3. Addition (+) and Subtraction (-)

Example

=10 + 5 * 2 Result: 20 (kyunki pehle multiplication hoti hai) Agar aap pehle addition chahte hain: =(10 + 5) * 2 Result: 30 ---

Common Mistakes Beginners Make

• Multiplication ke liye × use karna
• Formula ke start me = sign bhool jana
• Bracket ka galat use
• Wrong cell reference

---

Why Learning Excel Operators Is Important

Excel operators ke bina aap:

• Advanced formulas nahi seekh sakte
• Data analysis nahi kar sakte
• Office reports nahi bana sakte

Isliye Excel ka har learner sabse pehle operators ko achhi tarah samajhta hai. ---

Frequently Asked Questions

Excel me multiplication ke liye kaunsa symbol use hota hai?
Excel me multiplication ke liye “*” symbol use hota hai.

Kya power operator Excel me available hai?
Haan, Excel me power ke liye “^” operator use hota hai.

Kya ek hi formula me multiple operators use ho sakte hain?
Haan, Excel operator precedence ke according calculation karta hai.