Excel exercises
Excel exercises: Decisions with IF
IF turns a comparison into a decision, and this group builds the functions around it.
A comparison such as B2>100 already returns TRUE or FALSE, so IF is often a wrapper around one. AND, OR and NOT combine tests without stacking IFs inside each other. IFS handles more than two outcomes, SWITCH matches a list of names, and the IS functions ask what a cell holds before you ask what it is worth.
Seven exercises at levels 1 to 3. The pass-fail exercise is the shortest way to see the shape of the function, and the summary asks which one a question needs.
Two details carry most of the marks. The true and false results are evaluated left to right, so the first test that passes wins and the rest never run. Text returned by a test needs quotes around it and a number does not. Getting either wrong gives the right label in one row and the wrong one in the next.
A stale exercise is one you finished two weeks ago or longer. One that needs practice took a hint, or more than one try.
0 of 7 complete
- IF: one test, two answers Write a decision that returns one of two values, chosen by a single test.
- TRUE and FALSE: what a comparison returns Paid Read a comparison as a logical value that other formulas can act on.
- AND, OR and NOT: combining tests Paid Combine several tests into one answer, and choose AND or OR to match the question.
- IFS: more than two outcomes Paid Read a score into one of several bands with a single ordered function.
- SWITCH: match a list of values Paid Translate a short fixed list of codes into labels in one formula.
- ISBLANK, ISNUMBER, ISTEXT: reading a cell's type Paid Tell an empty cell from a text cell and a number, and read the answer as a logical value.
- Logical functions: putting the pieces together Paid Combine a logical test, a combined test and a rounded calculation in one formula.