Namaskar dosto! Aaj hum Excel ke 3 important functions ke baare mein jaanne wale hain — IF, AND aur OR.
Ye teeno functions Excel mein logical conditions check karne ke kaam aate hain. Kiya aap Data Analytics, Office Work ya Excel Reporting seekhna chahte hain? To in functions ko samajhna app ke liye bahut zaroori hai.
Inki sbhi functions ki help se aap students ka Pass/Fail status check kar sakte hain. Iske sath sath app attendance calculate bhi kar sakte hain; aur iske sath hi multiple conditions ko bhi easily manage kar sakte hain.
Agar kisi kaam ko manually karne mein aapka ek ghanta ya kafi jyada time lagta hain. To app in sabhi Excel formulas ki help se kuch hi minutes mein ye kaam poora kr sakta hai.
What is IF Function in Excel?
Dosto, sabse pehle hum Excel ke IF Function ko samajhte hain.
IF Function kisi condition ko check karta hai. Agar condition TRUE hoti hai, to ek result show hota hai. Agar condition FALSE hoti hai, to doosra result show hota hai.
यदि आप Data Analyst Course सीखना चाहते हैं तो हमारी Technical Team से बात कर सकते हैं!
(HR: 9034756711 | MD: 9017940459)
Iska simple example hai student ke marks ke basis par Pass ya Fail status check karna.
IF Function ka Syntax
=IF(logical_test, value_if_true, value_if_false)
Is formula mein:
- logical_test: Jo condition aap check karna chahte hain.
- value_if_true: Condition sahi hone par jo result show hoga.
- value_if_false: Condition galat hone par jo result show hoga.
Yaad rakhiye, IF Function mein pehli result value TRUE ke liye aur doosri result value FALSE ke liye hoti hai.
IF Function ka Practical Example
Maan lijiye, hamare paas students ke names, marks aur attendance ki ek Excel sheet hai.
Ab humein check karna hai ki kaun-sa student Pass hai aur kaun-sa Fail.
Complete Lesson in This Video; So Watch Completely!! 👇 👇 👇
Hum maan lete hain ki 40 ya usse zyada marks wale students Pass hain aur 40 se kam marks wale students Fail hain.
Formula hoga:
=IF(B2>=40,”Pass”,”Fail”)
Yahan B2 mein student ke marks hain.
Agar B2 ki value 85 hai, to condition TRUE hogi aur result Pass aayega.
Agar marks 38 hain, to condition FALSE hogi aur result Fail aayega.
Is tarah aapko har student ke marks manually check karne ki zaroorat nahi padegi. Formula ko neeche drag ya copy karke poori sheet ka result nikal sakte hain.
Where is the IF Function Used in Excel?
IF Function ka use kai tarah ke decisions lene ke liye kiya ja sakta hai, jaise:
- Student ka Pass/Fail status.
- Employee ka Yes/No status.
- Target complete hua ya nahi.
- Payment received hai ya pending.
- Kisi condition ke basis par Eligible ya Not Eligible status.
Is tarah IF Function aapka kaam easy aur fast bana deta hai.
What is AND Function in Excel?
Dosto, ab hum Excel ke AND Function ko samajhte hain.
AND Function tab TRUE return karta hai jab uski saari conditions TRUE hoti hain.
Agar do ya teen conditions mein se ek bhi condition FALSE ho jaati hai, to AND Function ka result FALSE aata hai.
Maan lijiye, humein kisi student ka Pass status check karna hai. Iske liye do conditions hain:
- Student ke marks 40 ya usse zyada hone chahiye.
- Student ki attendance 75% ya usse zyada honi chahiye.
Agar dono conditions sahi hain, tabhi student ko Pass maana jayega.
AND Function ka Syntax
=AND(logical1, logical2)
Aap ismein zaroorat ke according additional conditions bhi add kar sakte hain.
AND Function ka Practical Example
Maan lijiye, B2 mein student ke marks hain aur C2 mein uski attendance hai.
Formula hoga:
=AND(B2>=40,C2>=75%)
Ab ise step by step samajhte hain.
Agar B2 mein 85 marks hain aur C2 mein 90% attendance hai, to dono conditions TRUE hain. Isliye result TRUE aayega.
Lekin agar marks 38 hain aur attendance 90% hai, to pehli condition FALSE hogi aur doosri condition TRUE hogi.
Aise mein AND Function ka result FALSE aayega, kyunki dono conditions ka TRUE hona zaroori hai.
Isi tarah agar marks sahi hain, lekin attendance 60% hai, tab bhi result FALSE aayega.
AND Function ka Use
AND Function ka use tab hota hai jab kisi result ke liye saari conditions satisfy karna hoti ho.
Aap iska use kar sakte hain:
- Student ke marks aur attendance check karne mein.
- Employee ki performance conditions check karne mein.
- Sales target aur attendance ko verify karne mein.
- Multiple eligibility conditions check karne mein.
Dosto, ek important baat yaad rakhiye: AND Function khud TRUE ya FALSE return karta hai. Agar aapko iski jagah Pass ya Fail jaise words dikhane hain, to aap ise IF Function ke saath combine kar sakte hain.
What is OR Function in Excel?
Dosto, ab hum teesre important function, OR Function, ko samajhte hain.
Digital Thinker Help – Best IT Company in Yamunanagar
OR Function, AND Function se thoda different hai.
AND Function mein saari conditions TRUE honi chahiye, jabki OR Function mein sirf ek condition ka TRUE hona bhi kaafi hai.
OR Function tab TRUE return karta hai jab kam se kam ek condition TRUE ho.
Agar saari conditions FALSE hain, tab result FALSE aata hai.
OR Function ka Syntax
=OR(logical1, logical2)
Ismein aap ek se zyada conditions check kar sakte hain.
OR Function ka Practical Example
Student ki eligible ko check karna hai ya nahi.
Is example mein do conditions hain:
- Student ke marks 90 ya usse zyada hon.
- Student ka special eligibility status YES ho.
Formula hoga:
=OR(B2>=90,D2=”Yes”)
Yahan B2 mein marks aur D2 mein Yes ya No status diya gaya hai.
Agar student ke marks 85 hain, to pehli condition FALSE hogi.
Lekin agar D2 mein Yes likha hai, to doosri condition TRUE hogi.
Isliye OR Function ka result TRUE aayega.
Ab maan lijiye, marks 85 hain aur D2 mein No likha hai. Dono conditions FALSE hain, isliye result FALSE aayega.
OR Function ka Use
OR Function ka use tab hota hai jab multiple conditions mein se kisi ek condition ka satisfy hona sufficient ho.
Iska use aap eligibility checking, employee reports, sales conditions aur data analysis mein kar sakte hain.
IF, AND, & OR Functions ko Combine Karna
Dosto, ab hum seekhenge ki IF Function ko AND aur OR ke saath kaise combine kiya jaata hai.
Jab kisi student ka result TRUE ya FALSE ki jagah Pass or Fail Eligible ya Not Eligible jaisa result chahiye tab ye combination kaafi useful hota hai.
IF + AND Function
Student ke marks 40 ya usse above hone chahiye aur attendance minimum 75% honi chahiye.
Formula:
=IF(AND(B2>=40,C2>=75%),”Pass”,”Fail”)
Is formula mein pehle AND Function dono conditions check karega.
Agar dono conditions TRUE hain, to IF Function Pass show karega.
Agar koi ek condition bhi FALSE hai, to IF Function Fail show karega.
Example:
- Marks: 85, Attendance: 90% — Pass.
- Marks: 38, Attendance: 90% — Fail.
- Marks: 85, Attendance: 60% — Fail.
Is tarah aap ek hi formula se dono conditions check karke final result nikal sakte hain.
IF + OR Function
Student tab eligible manna jayega jab uske marks 90 ya usse zyada hain ya uska special eligibility status YES hai.
Formula:
=IF(OR(B2>=90,D2=”Yes”),”Eligible”,”Not Eligible”)
Is formula mein OR Function pehle dono conditions check karega.
Agar kam se kam ek condition TRUE hai, to result Eligible aayega.
Agar dono conditions FALSE hain, to result Not Eligible aayega.
IF aur OR function ko combine karke hum multiple conditions ke basis outup result show kar sakte hain.
Difference Between IF, AND, and OR Functions in Excel?
Teeno functions ka use or unka basic difference samajhna bahut important hai.
IF Function: Ek condition check karke TRUE aur FALSE ke liye alag-alag results deta hai.
AND Function: TRUE tab return karta hai jab saari conditions TRUE hon. Ek bhi condition FALSE hone par result FALSE hota hai.
OR Function: TRUE tab return karta hai jab kam se kam ek condition TRUE ho. Result FALSE tab hota hai jab saari conditions FALSE hon.
In functions par achi command banne ka liye Excel mein practical practice karna zaroori hai.
Where Can You Practice Excel Functions?
Dosto, aap in functions ki practice alag-alag Excel sheets par kar sakte hain.
- Student marks aur result sheet.
- Employee attendance sheet.
- Sales report.
- Monthly performance report.
- Eligibility checking sheet.
- Data analysis reports.
Sabse pehle simple IF formula ki practice karein. Uske baad AND aur OR functions ko alag-alag use karein. Jab aapko in function ki basic knowledge ho jaaye tho IF ke saath AND aur OR combine karke example slove karne ki koshis karein.
Regular paratice se Jitni zyada practical practice karenge utna hi aapko formulas ka logic clear hota jayega.
Conclusion
To dosto, aaj ki Articles mein humne Excel ke teen important logical functions seekhe:
- IF Function: Condition ke basis par alag result show karta hai.
- AND Function: Jab saari conditions TRUE hon, tab TRUE return karta hai.
- OR Function: Jab kam se kam ek condition TRUE ho, tab TRUE return karta hai.
Humne example ko though practical ko samjha aur ye bhi dekha ki IF ko AND aur OR ke saath combine karke Pass/Fail aur Eligible/Not Eligible jaise results kaise generate kar sakte ha.
In formulas ka use student reports, employee sheets, attendance aur Data Analytics mein kiya ja sakta hai.
If this content is valuable for you, then please share it along with your friends, family members, pet lovers or relatives over social media platforms like as Facebook, Instagram, LinkedIn, Twitter, and more.
Do you have any experience, tips, tricks, or query regarding on this? You can drop a comment!