Microsoft Office Tutorials and References
In Depth Information
ALWAYS POINT TO CELL B10
ALWAYS POINT TO
Challenge: You want to create a formula that always points to cell B10. Normally,
if you have a formula that points to B10 or even $B$10, the formula changes if
you cut and paste B10 or if you insert or delete rows above row 10.
In Figure 37, a formula in D1 checks to see if a value is in cell B10. In Figure
38, even after items are deleted from rows 6, 8, and 9, the formula still reports
an item in B10, even though cell B10 is empty. This is because the formula has
changed to point to B7 in Figure 38.
Figure 37. h
is formula points to B10
Figure 38. h
e reference moves to B7 if you delete three rows above B10.