Level 1Formulas & ReferencesPractice, 2 min
Multiply price by quantity
The task
In D2, work out the line total for notebooks: price times quantity.
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.5 | 6 | |
| 3 | Pens (10 pack) | 7.25 | 2 |