Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 5

IF, AND, OR and IFS in Excel

Let a formula choose: one condition with IF, several with AND and OR, and many outcomes with IFS.

  1. A choice: IF. IF checks a condition. It returns one value when the condition is true and another when it's false. Show "Pass" in C2 if the score is 60 or more, otherwise "Fail"
  2. Two conditions: AND and OR. AND returns TRUE only when every condition is true. OR needs just one. Check in D2 if the customer is 18 or older AND has agreed to the terms
  3. Read the formula.
  4. Several outcomes: IFS. IFS checks conditions in order and returns the value of the first one that's true. No nesting needed. Give the score in B2 a grade in C2: A from 90, B from 70, C from 50
  5. Your turn: SWITCH. SWITCH compares one value with a list and returns the matching result: 1 becomes Low, 2 Medium, 3 High. Turn the priority number in B2 into a word, in C2

← All lessons