Help shape GoConqr. What should we add next?

Mind map

IF, OR and AND functions in Excel

Andrea Lozano English

Map content

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

Information

Description
Mind Map on IF, OR and AND functions in Excel, created by Andrea Lozano on 06/11/2017.
Created by
Andrea Lozano
Views
0
Rating

More on Spreadsheet formulas and functions

Feedback

What is it about?

What should we add next?