Question

a. In cell C15, create a formula without using a function that subtracts the vendor cost (cell C7) and the shipping cost (cell C9) from the sales price (cell C8), and then multiplies the result by the projected number of units for sale in 2021 (cell C10).

Answer 1

Excel formulas are used to illustrate functions.

The formula to enter in cell 15 is = (C8 - C7 - C9) * C10

The given parameters are:

• C7 = Vendor cost
• C9 = Shipping cost
• C8 = Sales price
• C10 = Projected number of test

So, the required formula is:

(C8 - C7 - C9) * C10

Excel formulas begin with the = sign

So, we have:

= (C8 - C7 - C9) * C10

Hence, the formula to enter in cell 15 is = (C8 - C7 - C9) * C10

Read more about Excel formulas at:

https://brainly.com/question/1285762