Samantha W.

asked • 09/16/24

excel question 2024

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 multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.

Lope D.

To solve this in Excel without using any functions, you'll want to apply proper absolute referencing so the formula behaves correctly when copied across. In cell B13, enter the following formula: =($B$6 - $B$5 - $B$7) * $B$8 This formula subtracts the values in B5 and B7 from B6, then multiplies the result by the value in B8 — all with absolute references, meaning the cell references won’t shift when copied. Once entered, simply drag or copy the formula from B13 to H13 — Excel will keep referencing the same B cells thanks to the $ symbols. Honestly, keeping track of which cells to lock with $ signs kind of reminds me of playing [url=https://eggycar-game.io/]Eggy Car[/url] — everything’s fine until you lean too far in one direction and it all falls apart. Precision matters in both!
Report

09/19/25

2 Answers By Expert Tutors

By:

Ricky L. answered • 09/17/24

Tutor
5 (36)

Active FinTech Consultant with CPA and PMP Credentials

See tutors like this
See tutors like this

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 multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.


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


Explanation: This formula specifies two main operations, first subtracting two values from B6 and then multiplying by B8. Importantly, since this specifies using absolute references, we can assume that the formula is meant to extend to multiple rows OR columns. Since the question is looking for us to copy the formula into a range of columns, we assume that the absolute reference should remain on the row not on the column. Once the formula is built, copy to the necessary cells and you are good to go!

Upvote • 0 Downvote
More
Report

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.