In the range D5:D9 on all five worksheets, Gilberto wants to project next year's sales for each accessory, rounded up to zero de

Question

28 days ago

6

In the range D5:D9 on all five worksheets, Gilberto wants to project next year's sales for each accessory, rounded up to zero de

cimal places so the values are easier to remember. In cell D5, enter a formula using the ROUNDUP function that adds the sales for batteries and chargers in 2021 (cell B5) to the sales for the same accessories (cell B5) multiplied by the projected increase percentage (cell C5). Round the result up to 0 decimal places. Fill the range D6:D9 with the formula in cell D5.
I just need the formula!!
A B C D
5
Batteries and chargers $ 123,274.42 1.50% $ 125,124

Computers and Technology

1 answer:

maria [1K] · Answer 1 · 2026-04-12T00:02:22+03:00

Response:

Input the following into D5:

=ROUNDUP((SUM(B5,B5)*C5),0)

Explanation:

Needed

First, sum B5 with B5, and then multiply that total by C5.

Store the rounded-up figure to 0 decimal points in D5

The calculation needed is illustrated as:

D5 = (B5 + B5) * C5 [Rounded to 0 decimal points]

In Excel, the equation used is:

=ROUNDUP((SUM(B5,B5)*C5),0)

Breaking down the formula above:

= ---> This signifies the start of every excel formula

ROUNDUP( -> Rounds the outcome upward

(SUM(B5,B5) ---> Combine B5 and B5

*C5) --> Multiply the result of that addition by C5

,0) ---> The result is rounded up to 0 decimal points

To replicate the formula from D6 to D9, simply drag down the formula from D5 to D9.

The resulting formulas will be:

=ROUNDUP((SUM(B6,B6)*C6),0)

=ROUNDUP((SUM(B7,B7)*C7),0)

=ROUNDUP((SUM(B8,B8)*C8),0)

=ROUNDUP((SUM(B9,B9)*C9),0)