When to Use Relative Cell References in Excel? These cell references that adjust itself when the cell is copied are called relative cell references in Excel. For example, the formula in cell D3 becomes B3*C3 and the formula in D4 becomes B4*C4. When you do it, you will notice that the cell reference automatically adjusts to refer to the corresponding row. Now, instead of entering the formula for all the cells one by one, you can simply copy cell D2 and paste it into all the other cells (D3:D8). To calculate the total for each item, we need to multiply the price of each item with the quantity of that item.įor the first item, the formula in cell D2 would be B2* C2 (as shown below): Let me take a simple example to explain the concept of relative cell references in Excel. What are Relative Cell References in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |