Question

In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and

B7 from cell B6 and then multiples the result by cell B8. please help with excel!! I'm so lost

Answer 1

To subtract the values of cells B5 and B7 from cell B6 and then multiply the result by cell B8 using absolute references in Excel, use the formula =($B$6-$B$5-$B$7)*$B$8.

Step-by-step explanation:

To subtract the values of cells B5 and B7 from cell B6 and then multiply the result by cell B8 using absolute references in cell B13, you can use the following formula:

=($B$6-$B$5-$B$7)*$B$8

This formula subtracts the values in cells B5 and B7 from the value in cell B6, and then multiplies the result by the value in cell B8. The use of absolute references with the dollar sign ($), locks the cell references so that they do not change when the formula is copied to other cells.