MICROSOFT EXCEL STEP BY STEP GUIDE - ICT lounge

The $ symbols used in the A1 cell reference tell excel to only use the contents of that particular cell when the formulae is replicated into cells B4 and B12. This is known as Absolute ell Referencing [. Use the Autofil Drag Handles in cell B3 to copy the formula into the cells down to B12. The results should look like this: ................
................