hardGXBank · lookupBasic
Assign a credit tier from a score, using a range lookup
A1:A4 holds the minimum score for each GXBank credit tier (ascending), B1:B4 the tier name. E1 holds an applicant's score, which will rarely match a threshold exactly. Write a formula in F1 that returns the tier whose threshold is the largest one at or below the applicant's score.
Starting grid
A1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | 0 | Bronze | 1800 | |||
| 2 | 500 | Silver | ||||
| 3 | 1500 | Gold | ||||
| 4 | 5000 | Platinum |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime