Using constants in formulas
You are calculating the total cost of products based on their price and the number of units sold. The prices of the products are listed in column A, the number of units sold is listed in column B, and you want to multiply the price by the units sold in column C. You also want to apply a fixed discount of 10% from cell D2 to all the totals. Your task is to write a formula that you can drag down to calculate the total cost for each product after the discount is applied.
Inspect the price, quantity, and fixed discount cells in Table 1 before choosing a formula.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Price | Units Sold | Total Cost | Discount |
| 2 | 10.00 | 5 | 10% | |
| 3 | 15.00 | 3 | ||
| 4 | 12.00 | 4 | ||
| 5 | 8.00 | 6 |
You need to calculate the total cost for each row as Total Cost = Price * Units Sold * (1 - Discount).
Which formulas can you use in C2 and drag down to calculate the total cost for each product, applying the fixed discount from D2? (Multiple answers may be correct.)
=A2 * B2 * (1 - D2)=A2 * B2 * (1 - $D$2)=A$2 * B$2 * (1 - D$2)=$A2 * $B2 * (1 - D$2)