4.1 Formula vs Function, Math Operators & BODMAS Order

= sign se formula start hona, +, -, *, /, ^, & operators, comparison operators (>, <, >=, <=, <>), aur Excel ka BODMAS / PEMDAS rule.

---

Excel 2024 Complete Notes — Chapter 4

Excel Formulas & Functions — Fundamentals

Language: Hinglish | Level: Basic to Advanced

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

1. Chapter Overview

Is chapter mein aap seekhenge:

1. Formula aur Function kya hain
2. Formula likhne ke rules
3. Arithmetic operators
4. Comparison aur text operators
5. Cell references: Relative, Absolute aur Mixed
6. SUM, AVERAGE, MIN, MAX
7. COUNT, COUNTA, COUNTBLANK
8. Formula copy aur AutoFill
9. Order of Operations (BODMAS/PEMDAS)
10. Formula errors aur unke solutions
11. Practical examples aur exercises ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

2. Formula Kya Hai?

Formula ek expression hai jo values, cell references, operators aur functions ka use karke calculation karta hai.

Excel formulas aam taur par equal sign (=) se start hote hain.

Examples:

=A1+B1

=A2*B2

=(A1+B1)/2

=SUM(A1:A10)

Agar A1 mein 10 aur B1 mein 20 hai, to formula =A1+B1 ka result 30 hoga.

Formula ke Parts

Example:

=A1+B1

• = : Formula start karta hai
• A1 : Pehli cell reference
• • : Addition operator
• B1 : Doosri cell reference ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

3. Function Kya Hai?

Function Excel ka built-in formula hai jo specific calculation karta hai.

Examples:

=SUM(A1:A5)

=AVERAGE(B1:B10)

=MAX(C1:C20)

Function ke main parts:

• Function name, jaise SUM
• Opening parenthesis (
• Argument ya range
• Closing parenthesis )

Example:

=SUM(A1:A5)

Yahan SUM function A1 se A5 tak numeric values ka total calculate karta hai.

Formula Aur Function Mein Difference

Formula:

=A1+B1+C1

Function:

=SUM(A1:C1)

Dono same values ka total de sakte hain. Function bade ranges ke liye convenient hota hai.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

4. Excel Formula Enter Karne Ka Tarika

1. Excel workbook open karein.
2. A1 mein 10 enter karein.
3. B1 mein 20 enter karein.
4. C1 select karein.
5. Type karein: =A1+B1
6. Enter press karein. Expected result: C1 mein 30.

Formula Bar mein formula =A1+B1 dikh sakta hai, jabki cell mein calculated result 30 dikhega.

Formula edit karne ke tarike:

• Cell select karke F2 press karein.
• Formula Bar mein click karein.
• Formula ko replace karke Enter press karein. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

5. Arithmetic Operators

| Operator | Kaam | Example | Result |

|---|---|---|---|

| + | Addition | =10+5 | 15 |

| - | Subtraction | =10-5 | 5 |

| * | Multiplication | =10*5 | 50 |

| / | Division | =10/5 | 2 |

| ^ | Power | =2^3 | 8 |

| % | Percentage operator | =200*10% | 20 |

[!NOTE] Important:

Excel mein multiplication ke liye * aur division ke liye / use hota hai.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

6. Comparison Operators

Comparison operators do values ko compare karte hain.

| Operator | Meaning | Example |

|---|---|---|

| = | Equal to | =A1=B1 |

| > | Greater than | =A1>B1 |

| < | Less than | =A1<B1 |

| >= | Greater than or equal to | =A1>=B1 |

| <= | Less than or equal to | =A1<=B1 |

| <> | Not equal to | =A1<>B1 |

Example:

A1 = 50

B1 = 40

Formula:

=A1>B1

Expected result: TRUE.

Formula:

=A1=B1

Expected result: FALSE.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

7. Text Concatenation Operator

Ampersand (&) ka use text ko join karne ke liye hota hai.

Example:

A1 = Aman

B1 = Sharma

Formula:

=A1&" "&B1

Expected result:

Aman Sharma

Yahan " " ek space add karta hai.

Ek aur example:

="Total Marks: "&C1

Agar C1 mein 85 hai, to result hoga:

Total Marks: 85

Formatting ke saath numbers ko text mein join karte waqt TEXT function useful hota hai; ise advanced functions mein detail se seekhenge.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

8. Order of Operations

Excel expressions ko precedence rules ke hisaab se calculate karta hai. Parentheses calculation order control karne mein help karte hain.

---

Hands-on Practice Exercise

[!TIP] Open Microsoft Excel 365 / 2024 on your computer right now and practice each step described above. Memorize the keyboard shortcuts and try them in a fresh worksheet.

• Complete the practical walkthrough in Excel.
• Verify formatting and formula results.
• Attempt the chapter knowledge quiz when ready.