Rules with several conditions
Exercise 1 of 3
Highlight North orders over 50. In D2, write a rule that is TRUE only when both are true.
About this lesson
Combine conditions inside one rule with AND, OR and NOT, or compare with <> for "is not".
In this lesson
- Highlight North orders over 50. In
D2, write a rule that is TRUE only when both are true. - Highlight orders that are coffee or at least 60. In
D2, write a rule that is TRUE when either is true. - Highlight every order that is not from the South. Write the rule in
D2.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in D2 and press Enter to check.