Question

In the range D5:D9 on all five worksheets, Gilberto wants to project next year's sales for each accessory, rounded up to zero decimal 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

Answer 1

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

Step-by-step explanation:

I followed Mr. Royal's explanation but the numbers just would not match.

I adjusted and used the formula above in cell D5 and I was able to get the correct sum.