Use `IF` to test a condition and return one value if TRUE and another if FALSE
Syntax: `=IF(logical_test, value_if_true, value_if_false)`
Example: `=IF(A1>50,”Pass”,”Fail”)`
Use `AND` to test multiple conditions at the same time
Syntax: `=AND(logical1, logical2, …)`
Example: `=AND(A1>50,B1=”Yes”)`
Combine `IF` and `AND` to return a result only when all conditions are TRUE
Syntax: `=IF(AND(logical1, logical2, …), value_if_true, value_if_false)`
Example: `=IF(AND(A1>50,B1=”Yes”),”Approved”,”Denied”)`
Use `AND` inside `IF` when all conditions must be met
Use cell references in the logical tests instead of hardcoded values when possible
Keep text values in double quotes
Use comparison operators like `>`, `<`, `=`, `>=`, `<=`, `<>`
Nest additional `IF` functions if you need more than two outcomes
Example: `=IF(AND(A1>=60,B1>=60),”Eligible”,”Not Eligible”)`