Level 2LogicPractice, 3 min
AND: qualify a lead
The task
A lead is Qualified when its score is at least 70 and the company has at least 50 employees. Otherwise it's Nurture. Label the lead in row 2, in E2.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Lead | Score | Employees | Country | Status |
| 2 | Fieldstone | 82 | 35 | US | |
| 3 | Cobalt Labs | 64 | 220 | CA | |
| 4 | Quillworks | 91 | 140 | US |