Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RIGHT. RIGHT(text, n) returns the last n characters of a text. It is the mirror of LEFT: count from the end instead of the start. If the part you need always has the same length, RIGHT is all you need.
=RIGHT("Order 50001",5) gives 50001Brightline's stock count sheet needs the pack unit for each line. The last two letters of every SKU say how it is packed: BX box, CS case, PK pack, EA each.
In C2:C9, return the two-letter pack unit at the end of each SKU in column A. Use a formula that points at column A.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Product | Pack unit | |||||
| 2 | PP-102-BX | Recycled Paper A4 (500) | ||||||
| 3 | CK-202-PK | Filter Coffee 1kg | ||||||
| 4 | CL-301-CS | All-Purpose Cleaner 5L | ||||||
| 5 | DS-403-EA | Stapler Heavy Duty | ||||||
| 6 | CK-205-CS | Oat Milk 12-pack | ||||||
| 7 | PP-104-EA | Toner Cartridge Color | ||||||
| 8 | CL-304-BX | Trash Bags (200) | ||||||
| 9 | DS-402-PK | Sticky Notes (24) | ||||||
| 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