help with the formula making.

Question

1. In cell B14, create a formula without using a function that adds 1 to the value in cell B12 and then multiplies the result by the value in cell B13. In this formula, use a mixed reference for cell B12 by including an absolute reference to row 12. Copy the formula from cell B14 to the range B15:B17 and then copy the formulas from the range B14:B17 to the range C14:H17.

Answer 1

I think you are referring to Excel. If you are, then the solution would be to:

1) Create a mixed reference (B$12) which means the row (12) is fixed using $, but the column B can change when copied across columns.

2) Then put a +1 to add 1 to the value

3) Multiply the result by the value by the value in B13 by doing *B13

So, the final formula would be:

=(B$12 + 1) * B13

You would then copy B14 down to B15:B17. So, you could copy and paste or drag it down with the mouse to the other cells. Lastly, you can apply the same method to then copy the formulas from the range B14:B17 to the range C14:H17.