Cell Referencing Examples

Please purchase the course before starting the lesson.

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.

Back to: Advanced Excel Course > Function and Formula Basics