AND, OR and NOT
To test more than one condition, combine them: AND(test1, test2) is true only if all are true; OR(test1, test2) is true if at least one is; NOT(test) flips true to false. Put them inside IF to make richer decisions.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
`AND(TRUE, FALSE)` gives...
Your turn: write the code
In C2:C4 show 'Discount' if the customer is a member (B) OR spent more than 100 (A), otherwise 'Full price'.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.