mediumZalora · cleaning
Clean a messy discount label into a usable decimal
Column A holds Zalora discount labels typed by hand, like " 15% off " — with stray whitespace and a trailing " off" label. Write formulas in B1:B2 that turn each label into a plain decimal fraction (e.g. 15% off becomes 0.15).
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | 15% off | |
| 2 | 40% off |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
B1
| A | B | |
|---|---|---|
| 1 | 15% off | |
| 2 | 40% off |