easySetel · logical
Classify a member's loyalty tier by monthly spend
Column A holds one Setel member's monthly fuel spend (RM). Write a formula in B1 that returns their loyalty tier: "Bronze" for spend under 100, "Silver" for spend under 300, otherwise "Gold".
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | 180 |
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 | 180 |