Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ISNUMBER and VALUE. Numbers stored as text look right but SUM skips them. ISNUMBER(value) is TRUE only for real numbers, so it finds the fakes. VALUE(text) turns text that looks like a number, even with $ or a thousands comma, into a real number; on a real number it changes nothing.
=VALUE("1,250.00") gives 1250Finance pasted spring refunds from an email. Some amounts came in as text (with dollar signs or stray spaces), so the total in F2 quietly skips them.
In C2:C9, show TRUE when the amount in column B is a real number and FALSE when it is text. In D2:D9, use VALUE to turn every amount into a number. In F3, total the converted amounts in D2:D9.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Refund (import) | Is a number? | Refund | ||||
| 2 | 50128 | 124.4 | Total as imported | 429.90 | ||||
| 3 | 50214 | 42.00 | Total after fix | |||||
| 4 | 50232 | $326.00 | ||||||
| 5 | 50251 | 221.5 | ||||||
| 6 | 50259 | 430.70 | ||||||
| 7 | 50254 | $288.25 | ||||||
| 8 | 50272 | 84 | ||||||
| 9 | 50316 | 27.10 | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe