Home › Learn Excel › Lesson 5
Let a formula choose: one condition with IF, several with AND and OR, and many outcomes with IFS.
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"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 termsIFS 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 50SWITCH 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