FormulaCamp
Completed
5. Advanced Formulas · Formula Builders · 20 min

16. Practice: Advanced Formulas

Lesson 16 of 20
Task 1 of 6
  1. Give cell I1, which holds the rate, the name "PerLb".

Lesson theory

A courier service calculates shipping costs. The code and destination are stored together in one cell, and the rate per pound sits in a separate cell. Let's make the calculation clear: names instead of addresses, LET instead of long repetitions.

Tip: a name is created in the Name Box to the left of the formula bar. Select the cell, type the name and press Enter.

Practice is part of Pro

The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.