Lesson 3: Your first formula
- Click D2
- Type
=B2*C2and press Enter
| A | B | C | D | |
|---|---|---|---|---|
| 1 | What we buy | Price | Amount | Total |
| 2 | Balloons | 2 | 30 | |
| 3 | Plates | 0.5 | 40 | |
| 4 | Pizza | 45 | 4 | |
| 5 | Juice | 8 | 6 | |
| 6 | Everything | |||
| 7 | ||||
| 8 | Budget | 400 | ||
| 9 | Left |
- D2 = 60, using a formula
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
How to write a formula in Excel: the equals sign, cell references, multiplying, adding and subtracting. You can type = and then click B2 with the mouse instead of typing it. In lesson 5 you will learn to fill rows like these with a single drag. Change the pizza amount to 5 and watch every total update by itself.
Explore more: Excel course: all lessons, and SUM and AVERAGE.