From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Working with relative, absolute, and mixed references
From the course: Excel 2016 Essential Training
Working with relative, absolute, and mixed references
- We're looking at a worksheet called Absolute in our workbook 03 - Creating Formulas and Functions. In cell F2, we're about to calculate a new salary not only for Lisa but for all the others in our list here. Now, if everybody's going to get $2,000 more, we could write a simple formula here, equal E2, type it or click it, plus 2,000. And we can copy this down the column. Even before pressing Enter, we can point to the lower right-hand corner. Click and drag downward, and that formula will have been copied downward, and our original formula, E2 plus 2,000, has been copied here automatically to say E3 plus 2,000, and this is what we call a relative reference. As we copy a formula into a different row, the row reference in the formula, the row 2, becomes row 3, and becomes row 4, and down at the bottom, row 13. That happens automatically. It's referred to as a relative reference. But what if our salary calculation is going to be based on a percent increase 2.1%? Instead of this formula,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.