Module 02: Make formulas work for you

LESSON 05 / Beginner · ABOUT 15 MIN

Build your first formulas from cell references

Calculate order totals, inspect the expression behind the result, and test how parentheses change arithmetic.

Before you start

Windows desktop: Excel 2016, 2019, 2021, 2024, and Microsoft 365. Mac/web menus and shortcuts differ. No dynamic arrays required.

Useful first: Enter and correct data without changing its meaning · Format numbers without confusing display and value

By the end, you can…

Enter an arithmetic formula using references instead of repeated constants.
Explain multiplication-before-addition with a concrete order total.
Change an input and check the corresponding calculated output.

YOUR PRACTICE FILE

Small data. A result you can check.

Inputs only. Paste at A1 of a blank worksheet, then enter the formulas from the lesson; the TSV contains no formulas.

Download practice data

View the raw practice data

Item	Quantity	Unit price	Shipping
Lamp	3	18	5
Tray	5	7	0
Hook	2	4	2

01Separate inputs from calculated results

Create a Calculations sheet and paste at A1. B, C, and D contain Quantity, Unit price, and one Shipping charge per order. Add Total in E1, keeping calculated results separate from inputs.

For Lamp, three units at 18 cost 54; one shipping charge adds 5, giving 59. Work out this small answer independently before entering the formula.

Row	Item	Quantity	Unit price	Shipping
2	Lamp	3	18	5
3	Tray	5	7	0
4	Hook	2	4	2

02Enter the expression and inspect it

Click E2, type =B2*C2+D2, and press Enter. The equals sign begins the formula, * multiplies, and + adds. The worksheet should display 59. Select E2 again: the formula bar shows the expression rather than just its calculated answer.

Enter =B3*C3+D3 in E3 and =B4*C4+D4 in E4. These rows should produce 35 and 10. Notice that each row refers to its own inputs. In the next lesson you will copy formulas safely instead of retyping them.

=B2*C2+D2

Enter in E2. With B2=3, C2=18, and D2=5, the expected result is 59.

03Parentheses express a different calculation

In G2, enter =B2*(C2+D2). It returns 69 because shipping is added before multiplication, charging it three times. This is a different rule, not a syntax error.

For ordinary arithmetic here, Excel multiplies and divides before adding and subtracting. Parentheses override that order. You can also use - for subtraction and / for division. Write the business rule in words before deciding where parentheses belong; correct arithmetic cannot rescue the wrong rule.

04Use a controlled change to check the link

Change only B2 from 3 to 4. Under normal automatic calculation, E2 becomes 77 while E3 and E4 remain 35 and 10. G2 becomes 92 because its alternative rule still multiplies the shipping charge.

If a formula displays as text, check for Text formatting or a leading apostrophe; re-enter it in a General cell. If a working result stays stale, inspect calculation mode. Never overwrite the formula with an expected answer.

PUT IT INTO PRACTICE

Calculate three totals, then test one input change.

Paste the sample at A1 and add Total in E1.
Enter the row-specific formulas in E2:E4.
Enter the alternative expression in G2 and explain its different result.
Change B2 to 4 and inspect both E2 and G2.

Show the worked answer

Initial E2:E4 results are 59, 35, and 10, totaling 104 by independent addition.

After B2 becomes 4, E2:E4 are 77, 35, and 10, totaling 122.

G2 changes from 69 to 92 because shipping is multiplied with the quantity.

The formula bar in E2 continues to show =B2*C2+D2.

Check your work

Inputs and outputs occupy separate columns.
The results agree with hand arithmetic.
Only results depending on the edited quantity change.

CHECK YOUR UNDERSTANDING

One question before you move on.

With B2=3, C2=18, and D2=5, which formula adds shipping once after the unit cost?=B2*(C2+D2)=B2*C2+D2=B2+C2+D2

Ready for the next step?

Mark this lesson when you can explain the idea and reproduce the practice result.

Your checklist stays on this browser.

NEXT LESSONCopy formulas while keeping shared inputs fixed

Keep the skill close.

FIELD GUIDEExcel SUM Returns Zero or Misses Values: Convert Numbers Stored as Text WORKSPACE TOOLCSV import checker

Reference notes

These lessons use original examples. Check Microsoft’s documentation for details and platform-specific options.

Prepared September 13, 2026 · Column Harbor editorial team. Menu locations and available functions can vary by Excel version.