Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 4

Absolute references and percentages in Excel

Lock a cell with $ so formulas copy correctly, work out percentages and repair numbers stored as text.

  1. Lock a cell with $. Every rep gets the same rate from E2. Lock it with dollar signs ($E$2), so the formula still points to E2 when you copy it down. Work out Emma's commission in C2, with the rate in E2 locked
  2. What happens when you copy?.
  3. Percentage change. Percentage change = (new − old) / old. The brackets make Excel subtract first. Work out in D2 by what percentage bike sales went up
  4. Text to number: VALUE. A2 looks like a number, but it's stored as text (it sits on the left). VALUE turns it into a number you can calculate with. Turn the text in A2 into a real number in B2
  5. Your turn: hours worked. Excel stores time as part of a day. End minus start gives a time; multiply by 24 to get hours like 8.5. Work out in D2 how many hours Mia worked, as a decimal number

← All lessons