Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
Arithmetic
96 minus 60 leaves 36. The same four signs do all the maths in a sheet: + - * /.
Try this lesson free →Example
Revenue isn't profit. Take away what the stock cost:
=D2-E2| Day | Product | Qty | Revenue | Cost | Profit | Price each |
|---|---|---|---|---|---|---|
| Mon | Phone case | 12 | 96 | 60 | ||
| Tue | Charger | 8 | 120 | 70 | ||
| Wed | Earbuds | 5 | 175 | 100 | ||
| Thu | Phone case | 15 | 120 | 75 | ||
| Fri | Screen guard | 20 | 100 | 55 | ||
| Total | 611 | 360 |
Key points
+ -Add and subtract. =D2-E2 is revenue minus cost: the profit.
* /Multiply with *, divide with /. =D2/C2 is the price of one item.
Use addressesWrite D2, not 96, so the answer updates when the data changes.
Put together: =D2-E2 is Monday's profit, and =D2/C2 is what one phone case sold for.
Practice
1. In F3, work out Tuesday's profit: revenue (D3) minus cost (E3).
=D3-E32. In G2, work out the price of one phone case on Monday: revenue (D2) divided by quantity (C2).
=D2/C23. In F7, work out the week's total profit: total revenue (D7) minus total cost (E7).
=D7-E74. In F4, work out Wednesday's profit.
=D4-E45. In G3, work out the price of one charger on Tuesday.
=D3/C3Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →