IF Function Excel: Conditions लगाना सीखो

Harsh Decode

UPGRADE WITH HARSH

IF Function Excel: Logical Conditions का Master Guide

By Harsh Saxena · 6 min read · Excel Formulas

Key Insight: IF function Excel ka sabse powerful logical function hai. Ye aapko "agar ye hua to ye karo, warna wo karo" logic lagane deta hai. Data analysis, reports, aur automation ka base hai.

Is Guide Me Kya Sikhenge

01 IF function ka syntax aur 3 arguments

02 Text, Numbers, aur Calculations ke saath 5 examples

03 Common errors aur unke solutions

04 Nested IF aur Best Practices

IF Function Kya Hai?

IF function aapko logical comparison karne deta hai kisi value aur expected result ke beech.

Ek IF statement ke do results ho sakte hain:

1 Comparison True Hai

Pehla result return hoga

2 Comparison False Hai

Doosra result return hoga

Example:

=IF(C2="Yes",1,2)

Matlab: Agar C2 me "Yes" hai to 1 do, warna 2 do

Syntax Breakdown

IF(logical_test, value_if_true, [value_if_false])

Argument	Required	Description
logical_test	REQUIRED	Jo condition test karni hai
value_if_true	REQUIRED	True hone par jo value chahiye
value_if_false	OPTIONAL	False hone par jo value chahiye

Quick Examples:

=IF(A2>B2,"Over Budget","OK")

=IF(A2=B2,B4-A4,"")

5 Practical Examples

1

Text Comparison

Cell C2 me "Yes" hai to 1 do, warna 2 do

=IF(C2="Yes",1,2)

Result: D2 me agar C2="Yes" hai to 1 aayega, nahi to 2

2

Number Comparison

Cell C2 me 1 hai to "Yes" likho, warna "No"

=IF(C2=1,"Yes","No")

IF function text aur numbers dono evaluate kar sakta hai

3

Budget Check

Actual budget se zyada hai ya nahi

=IF(C2>B2,"Over Budget","Within Budget")

Agar C2 > B2 hai to "Over Budget" warna "Within Budget"

4

Mathematical Calculation

Text ki jagah calculation return karna

=IF(C2>B2,C2-B2,0)

Agar Actual > Budgeted hai to difference calculate karo, warna 0 return karo

5

Sales Tax Calculation

Taxable item hai to 8.25% tax lagao

=IF(E7="Yes",F5*0.0825,0)

Agar E7="Yes" hai to F5 ka 8.25% calculate karo, warna 0

💡 Important: Text ko quotes me likhna zaroori hai: "Text". Exception: TRUE aur FALSE ko quotes nahi chahiye, Excel khud samajh jata hai.

Common Problems & Solutions

Problem	Kya Galat Hua	Solution
0 in cell	value_if_true ya value_if_false argument missing hai	Dono arguments me text add karo, ya TRUE/FALSE likho
#NAME?	Formula galat spell hua hai	IF spelling check karo, quotes sahi lagao

Pro Tips

✓

Nested IF Use Karo

Multiple conditions check karne ke liye IF ke andar IF daal sakte ho: =IF(A1>90,"A",IF(A1>80,"B","C"))

✓

Mathematical Operators

Sirf = nahi, >, <, >=, <=, <> bhi use kar sakte ho comparisons ke liye

✓

Error Handling

IF function errors bhi evaluate kar sakta hai. IFERROR ke saath combine karke aur powerful banao

IF Function Master Kar Liya?

Excel friends ke saath share karo jo abhi bhi manual checking karte hain!

WhatsApp Par Share Karein

Comment me batao - kaunsa example sabse useful laga?

Harsh Decode

Upgrade With Harsh · Excel Tips in Hindi

By Harsh Saxena

WhatsApp pe Share karo