Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
MID. MID(text, start, n) returns n characters starting at position start, counting the first character as 1. Count along the text to find where the part you need begins, then say how long it is.
=MID("INV-50001-W",5,5) gives 50001The pick list for Monday only has SKUs. To match them with the product list you need the three-digit product number in the middle of each code, such as 201 in CK-201-PK.
In B2:B9, return the three-digit product number from the middle of each SKU in column A.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Product number | ||||||
| 2 | CK-201-PK | |||||||
| 3 | PP-104-EA | |||||||
| 4 | CL-302-CS | |||||||
| 5 | DS-403-EA | |||||||
| 6 | CK-206-BX | |||||||
| 7 | PP-105-PK | |||||||
| 8 | CL-304-PK | |||||||
| 9 | DS-405-EA | |||||||
| 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