If you add rows above the referenced cell or columns above the referenced cell, the cell's reference will change to reflect its new position adding a row above Cell A1 and a column to its left will change its reference to B2 in any formula the cell is referenced in. The most common coordinate reference is to use the letter or letters representing the column followed by the number of the row the cell is in: A1 refers to the cell in Column A, Row 1. ![]() You refer to those cells with a coordinate reference of the row and column the cell is in. While you can include numeric constants in your formulas, in most cases you'll use values entered in other cells (or the results of other formulas displayed in those cells) in your formulas. ![]() Use coordinate references for cells that contain the values used in your formula.
0 Comments
Leave a Reply. |