Level 3LET and LAMBDAPractice, 3 min
LET: name the pieces
The task
In F2, work out the program's margin after the agency fee: (revenue minus spend minus the fee on spend) divided by revenue. Use
LET to name the totals first, so the formula reads like the sentence.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Campaign | Spend | Revenue | Agency fee | Margin | |
| 2 | Brand terms | $2,400 | $14,400 | 12% | ||
| 3 | Product terms | $5,200 | $17,600 | |||
| 4 | Lookalike 1% | $3,800 | $9,120 | |||
| 5 | Retargeting | $1,900 | $8,550 | |||
| 6 | Webinar promo | $600 | $4,380 | |||
| 7 | Prospecting video | $4,600 | $3,980 |