The formula B2*C2 gives the sales revenue for product-1. To calculate the sales revenue, we multiply the number of units sold by the unit price. We want to calculate the sales revenue by using the equation Units Sold*Unit Price=Sales Revenue. Let us consider another example of relative references in Excel. Thus, cell B3 applies summation to the values of cells B1 and B2. After copying cell A3, as we move one cell to the right, A1 becomes B1 and A2 becomes B2. The output of cell A3 depends on cells A1 and A2. This is because cell A3, which is copied, contains a formula, not a value. On copying cell A3 and pasting in cell B3, the answer is not 100. We can either apply the Excel formula of addition to cell B3 or copy and paste the formula of cell A3 to cell B3. Now, with different values of cells B1 and B2, we want a summation in cell B3.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |