Question

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products

Answer 1

Answer:

Kindly check explanation

Explanation:

To obtain the result of the subtraction in cell D7:

While user has clicked on cell D7, press =, click on cell D5, -, click on cell D6 and press enter. The formula is in the form '=D5 - D6' ( referencing is omitted).

Once the formula has been entered into cell D7, the formula can be extended to across or beneath or both directions by clicking on cell D7, then around the lower right edge of the cell rectangle, a '+' sign shows up, right click and hold on the '+' sign then drag the mouse in your chosen direction. The calculation will be extended to all cells highlighted.