Excel is a powerful tool for data calculation and manipulation. To make the most of Excel’s capabilities, it’s essential to know how to use the functions available. Two of the most commonly used functions in Excel are ROUND and SUM. The ROUND function is used to round numbers to a specified number of decimal places, while the SUM function is used to add up a range of cells. Combining these functions can be beneficial when working with large amounts of data that need precise calculations. This article will provide a step-by-step guide to show how to combine ROUND and SUM functions in Excel.

Step 1: Open Excel

Open Excel by clicking the Excel icon on your computer’s desktop or by searching for Excel in the Windows start menu. Once Excel is open, a blank workbook should appear.

Step 2: Enter the Data

Enter your data into the workbook. For instance, let’s consider the following data:

| A | B | C |
| ——— | ——— | ——— |
| Item | Price | Quantity |
| Apple | 0.5 | 100 |
| Banana | 0.3 | 150 |
| Orange | 0.4 | 200 |

Step 3: Calculate the Total Cost

In this example, we want to calculate the total cost of all the fruits purchased. To do so, we need to multiply the price of each fruit by its quantity and then sum up the values. In cell D2, type the following formula:

“`
=B2*C2
“`

This formula multiplies the price of the first fruit by its quantity. Now, drag the formula down to the other rows until all the values are calculated.

| A | B | C | D |
| ——— | ——— | ——— | ——— |
| Item | Price | Quantity | Cost |
| Apple | 0.5 | 100 | 50 |
| Banana | 0.3 | 150 | 45 |
| Orange | 0.4 | 200 | 80 |

Step 4: Sum the Total Cost

To get the total cost of all the fruits purchased, we now have to use a SUM function on the column D. In cell D5, type the following formula:

“`
=SUM(D2:D4)
“`

This formula adds up the values in cells D2 through D4, giving us the total cost of all the fruits purchased. Now, we should see the total cost displayed in cell D5.

| A | B | C | D |
| ——— | ——— | ——— | ——— |
| Item | Price | Quantity | Cost |
| Apple | 0.5 | 100 | 50 |
| Banana | 0.3 | 150 | 45 |
| Orange | 0.4 | 200 | 80 |
| Total | | | 175 |

Step 5: Round the Total Cost

In the above example, the total cost is calculated with two decimal places. However, we may need to round the total cost to zero or one decimal places, depending on our needs. In this scenario, we’re going to round the total cost to one decimal place.

To do so, we can use the ROUND function in combination with the SUM function. In cell D6, type the following formula:

“`
=ROUND(SUM(D2:D4),1)
“`

This formula rounds the total cost to one decimal place and displays the result in cell D6. Now we should have the rounded value of the total cost.

| A | B | C | D |
| ——— | ——— | ——— | ——— |
| Item | Price | Quantity | Cost |
| Apple | 0.5 | 100 | 50 |
| Banana | 0.3 | 150 | 45 |
| Orange | 0.4 | 200 | 80 |
| Total | | | 175 |
| Rounded | | | 175.0 |

Conclusion

Excel allows the use of a combination of functions to perform precise calculations. In this article, we have seen how we could combine the ROUND and SUM functions to get the total cost of all the fruits purchased and then round off the result to one decimal place. By following these basic steps, you can apply these functions more broadly to work with your data in your Excel spreadsheet.