Home › Learn Excel › Lesson 4
Lock a cell with $ so formulas copy correctly, work out percentages and repair numbers stored as text.
$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 lockedVALUE turns it into a number you can calculate with. Turn the text in A2 into a real number in B2