0 of 46 lessons complete.
Module 3: References · Lesson 17 of 46
Absolute References with $
Lock a reference with $ so it doesn't move when copied.
Step 1 of 20%
The conversion factor lives in D2. In B2, multiply A2 by $D$2. The dollar signs lock the reference so it always points to D2.
Target: B2
B2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Pressure (psi) | Pressure (kPa) | psi to kPa | |||
| 2 | 30 | 6.89476 | ||||
| 3 | 45 | |||||
| 4 | 60 | |||||
| 5 | 75 | |||||
| 6 | 90 | |||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $