Step 1 of 4
0:00/ par 3:30

First Formulas · Lesson 8

Your first formula

MissionGuided

Hartley & Co, an office down the street, ordered muffins for two meetings. Rosa needs the bill — and you're going to let the spreadsheet do the math.

How many muffins in total? In B5, add the two orders: type =B3+B4 and press Enter.

Show · Formulas

=cell+cell

A formula starts with an equals sign. Use cell names instead of the numbers themselves — then the answer updates when a number changes.

=B3+B4 adds the values in B3 and B4.

Using a hint costs the “no hints” star.
Work in · Other cells are read-only. Tip: click cells while typing a formula to insert them.
B5
fx
ABC
1
Catering order — Hartley & Co
 
 
2
 
 
 
3
Muffins (morning)
24
 
4
Muffins (afternoon)
18
 
5
Total muffins
 
 
6
 
 
 
7
Price per muffin
$3.50
 
8
Order total
 
 
9
Deposit paid
$40.00
 
10
Left to pay
 
 
11
Departments
4
 
12
Each department pays
 
 
13
 
 
 
14
 
 
 

Type your formula, press Enter to confirm, then Check (or Ctrl+Enter)