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 how to do in excel
GPT 3.5
=ROUNDUP(C5+G5,0)

Related Questions

Gilberto also wants to display the total accessory sales from the previous year. This data is stored... Gilberto wants to make some changes to all five worksheets, which have the same structure. Group... How to do this in excel explain step by step In the range D5:D9 on all five worksheets, Gilberto wan...