read more for all products, either press Ctrl+D or copy and paste cell D2 in the selected cells. It is reported annually, quarterly or monthly as the case may be in the business entity's income statement/profit & loss account. To determine the sales revenue Sales Revenue Sales revenue refers to the income generated by any business entity by selling its goods or providing its services during the normal course of its operations. So, we copy and paste the formula to the other cells.Īs we copy the formula from cell D2 to cell D3, the formula reference changes from B2*C2 to B3*C3. Applying this formula to all products would become tedious. 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.