Level 3LET and LAMBDAPractice, 3 min
ARRAYFORMULA for rows yet to come
The task
New items get added to this list all the time. In D2, write one formula that covers rows 2 to 10: price times quantity, but blank where there's no item yet.
=ARRAYFORMULA(IF(A2:A10="", "", B2:B10*C2:C10))The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Price | Qty | Line total |
| 2 | Notebook | $4.50 | 12 | |
| 3 | Pens (10 pack) | $7.25 | 4 | |
| 4 | Stapler | $12.00 | 2 | |
| 5 | Packing tape | $3.80 | 10 | |
| 6 | File folders | $6.00 | 5 | |
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 |