Formuladrill

Level 2: Logic and counting Exercise 34 of 118

Plan codes to prices

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Turn each plan code into its monthly price with SWITCH: B is 9, P is 19, E is 49, and any other code is 0. Fill C2 to C4.

What this exercise teaches

SWITCH compares one value against a list of exact matches, which reads better than a chain of IFs that all test the same cell. Without the default at the end, an unknown code returns #N/A.

A hint if you get stuck

SWITCH(value, match1, result1, match2, result2, ..., default). The last argument without a partner is the value for everything else.

Functions used: SWITCH

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Logic and counting