IF, OR and AND functions in Excel

IF, OR and AND functions in Excel

1. IF Function

   • IF(lógica_test,[value_if_true], [value_if_false])

2. AND, OR

   • =IF(AND(C2, >5,OR(D2,="Sales", D2="Support"))
     • If everything is following the rule = true statement
       • =IF(AND(C2, >5,OR(D2,="Sales", D2="Support")), E2*1.5*C2)
     • If something is not following the rule= false statement
       • =IF(AND(C2, >5,OR(D2,="Sales", D2="Support")), E2*1.5*C2,E2*C2)

3. Nested IF Function

   • Normal If function that is nesting another one in the formula
     • =IF(B4>=200000, B4*10%, IF(B4>=100000
       • IF TRUE
         • =IF(B4>=200000, B4*10%, IF(B4>=100000, B4*5%))
           • If i don't want in the format to appear FALSE, just add a coma between the % and first parenthesis