From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Absolute and relative references

Absolute and relative references

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Absolute and relative references

- When we use cell references in Excel formulas, normally we use what's called a relative reference. For example, in cell I2, I'm about to write a formula here, calculate a new salary increase for the first person. Everybody in this list is going to get a salary increase of $1,500. =G2+1500 enter we see the new amount. We'd like to do this for the entire column. It's over 700 rows, obviously we don't want to be rewriting the formula that many times, so testing this out, from the lower right-hand corner, the so-called fill handle, we'll click and drag down a few cells and it looks as if all these numbers are being incremented. What's our formula say in cell I3? The G2 has become G3 and down here it's become G4, and so every time we copy a formula downward, the row number gets higher so the reference to the row here, which in this example is 4, we copy it to here, now it's going to be 5 and so on. And, not a problem there and that's the way we would like it to work. We can easily copy…

Contents