CHAPTER 8 · INTERMEDIATE EXCEL
IF, AND, OR & IFERROR
Excel me decision-making formulas ka base IF hai. AND aur OR multiple conditions combine karte hain, aur IFERROR expected formula errors ko user-friendly result me convert kar sakta hai.
IF
pass-failExcel
=IF(B2>=40,"Pass","Fail")Condition true ho to first result, false ho to second result return hota hai.
AND
all conditionsExcel
=IF(AND(B2>=40,C2>=40),"Pass","Fail")AND tab TRUE deta hai jab sab conditions true hon.
OR
any conditionExcel
=IF(OR(B2="Yes",C2="Yes"),"Eligible","No")OR me koi ek condition true ho to result TRUE ho sakta hai.
IFERROR
safe divisionExcel
=IFERROR(A2/B2,0)Expected error cases ko readable fallback dene ke liye useful hai. Lekin unknown errors ko blindly hide karna good practice nahi hai.
Hinglish
IF se decision, AND/OR se multiple conditions, aur IFERROR se controlled fallback milta hai.