Computer literacy
How do you include delivery costs?
You track office supplies in Excel. For each item, multiply the quantity by its unit price and add the delivery cost.
Quantities are in B3:B7 and unit prices are in C3:C7. The fixed delivery cost for each item is stored in F3.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 2 | Item | Qty | Price, ₽ | Total, ₽ | Delivery, ₽ | |
| 3 | Pens | 359 | 16 | ? | 500 | |
| 4 | Pencils | 467 | 29 | |||
| 5 | Rulers | 150 | 10 | |||
| 6 | Squared notebooks | 273 | 17 | |||
| 7 | Ruled notebooks | 464 | 17 |
No answer selected
In the formula =B3*C3+$F$3, B3 and C3 change when copied down, while $F$3 stays fixed. For pens: 359 × 16 + 500 = 6,244 ₽.