Use `=IF(logical_test, value_if_true, value_if_false)`
Example: `=IF(A1>10,”Yes”,”No”)`
Use nested IF: `=IF(A1>10,”High”,IF(A1>5,”Medium”,”Low”))`
Use `=AND(condition1, condition2)` inside IF: `=IF(AND(A1>10,B1=”Yes”),”Pass”,”Fail”)`
Use `=OR(condition1, condition2)` inside IF: `=IF(OR(A1>10,B1=”Yes”),”Pass”,”Fail”)`
Use IF with blank result: `=IF(A1=””,””,A1*2)`
Use IF with text comparison: `=IF(A1=”Done”,”Complete”,”Pending”)`
Use IF with date comparison: `=IF(A1>TODAY(),”Future”,”Past”)`
Use IF with error handling: `=IFERROR(A1/B1,”Error”)`
Copy the formula down to apply it to more cells