![]() When a formula contains an absolute reference, no matter which cell the formula occupies the cell reference does not change: if you copy or move the formula, it refers to the same cell as it did in its original location. In the “A1” reference style (the default), there are three kinds of cell references: absolute, relative, and mixed. When a formula refers to a cell, it uses a cell reference. ![]() That’s one reason Excel formulas are so powerful - the results can change based on changes made in other cells. You probably know that a formula can refer to cells. ![]() For more information, see the article Display numbers as currency.ĭollar signs indicating absolute references
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |