Start with `=IF(`
Use the syntax `=IF(logical_test, value_if_true, value_if_false)`
Enter a condition to test, such as `A1>10`
Enter the result if the condition is TRUE
Enter the result if the condition is FALSE
Close the formula with `)`
Example: `=IF(A1>10,”Yes”,”No”)`
Example: `=IF(B2=”Pass”,100,0)`
Use nested IF functions for multiple conditions
Example: `=IF(A1>=90,”A”,IF(A1>=80,”B”,IF(A1>=70,”C”,”F”)))`
Combine IF with other functions when needed
Example: `=IF(AND(A1>10,B1<5),"Valid","Invalid")`
Example: `=IF(OR(A1=”Yes”,B1=”Yes”),”Approved”,”Denied”)`