# How to Round a Multiplication Formula in Excel (5 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

After performing a multiplication formula in Excel sometimes we need to round the output. There are many ways to do it in Excel. But in this article, I’ll show 5 easy methods to round a multiplication formula in Excel with sharp steps and clear illustrations.

## 5 Ways to Round a Multiplication Formula in Excel

To explore the methods, we’ll use the following dataset that represents some cloth items’ Prices and Discounts. ### 1. Use ROUND Function to Round a Multiplication Formula in Excel

In our very first method, we’ll use the ROUND function to round a multiplication formula in excel. That’s why I added a new column- E. We’ll keep one digit after the decimal while using the ROUND function.

Steps:

• Activate Cell E5.
• Then type the following formula in it-
`=ROUND(C5*D5,1)`
• Later, just hit the Enter button to get the output. Here, I got the rounded 11% discount of Price \$22.9 which is \$2.5.

• Next, drag down the Fill Handle icon to copy the formula for the other cells. Soon after, you will get the output like the image below. ### 2. Insert ROUNDUP Function to Round a Multiplication Formula

Now we’ll use the ROUNDUP function to round a multiplication formula. This function will always increase the last digit after decimal by one.

Steps:

• Write the following formula in Cell E5
`=ROUNDUP(C5*D5,1)`
• Later, press the Enter button for the result. • Then to get the other outputs, use the Fill Handle tool. Output after using the Fill Handle tool. ### 3. Use ROUNDDOWN Function in Excel to Round a Multiplication Formula

Here, we are going to use the ROUNDDOWN function for the task. It will keep the last digit as it is after the decimal.

Steps:

• In Cell E5, type the following formula
`=ROUNDDOWN(C5*D5,1)`
• Next, hit the Enter button. • Finally, use the Fill Handle tool to finish. And then you will get the result like the image below. ### 4. Use MROUND Function to Round a Multiplication Formula in Excel

Now let’s apply the MROUND function to do the task. It is used to round a number up or down to the multiple of a specified number. We’ll round to the multiple of 2.

Steps:

• Type the following formula in Cell E5
`=MROUND(C5*D5,2)`
• Press the Enter button to get the rounded value. • After that, drag down the Fill Handle icon to copy the formula. Now all the numbers are rounded. Read More: How to Multiply in Excel: Columns, Cells, Rows, & Numbers

### 5. Apply INT Function to Round a Multiplication Formula

In this last method, I’ll show how to use the INT function to round a multiplication formula. This function will only keep the integer portion of a number.

Steps:

• In Cell E5, write the following formula
`=INT(C5*D5)`
• Later, hit the Enter button to get the result. • Lastly, use the Fill handle icon over the cells E6:E9 to copy the formula. Now have a look that the INT function has rounded the numbers to integers. ## Practice Section

You will get a practice sheet in the Excel file given above to practice the explained ways. ## Conclusion

I hope the procedures described above will be good enough to round a multiplication formula in Excel. Feel free to ask any question in the comment section and please give me feedback.

## Related Articles Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

1. Reply Thanks for the tutorial, i find it very easy to understand and learn, many thanks for your effort

• Reply Hello, Bennie!

Regards
ExcelDemy Advanced Excel Exercises with Solutions PDF  