Cell Referencing Examples
Cell ref Ex 6
In the block C4 to G13 we want to create a matrix that tells us the total price based on th number of units in column B and selling price in row 4. So cell D5 would be =B5*D3. Use $ signs so that you can create one formula in C4 and copy it to the whole block.
To see the full course contents click here.