Microsoft Excel question.

Question

Create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from B6 and then multiples the result by cell B8.

Separate formula

Create a formula without using a function that adds 1 to the value in cell B12 and then multiplied the result by the value I. Cell B 13.

Answer 1

Create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from B6 and then multiples the result by cell B8.

=(B6-(B5+B7))*B8

Create a formula without using a function that adds 1 to the value in cell B12 and then multiplied the result by the value I. Cell B 13.

=(1+B12)*B13

Answer 2

See the Video above for a step by step solution in Excel.

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

Answer 3

Use building blocks to create a formula creating one step at a time:

start with =

use brackets aound minor function (subtraction two numbers)

use brackets around major function (subtract one number)

then simply multiply the result

=(b6-(b5+b7))*b8

click on 'enter'