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.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
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.
Read More: What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)
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.
Read More: If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)
Similar Readings
- How to Multiply Two Columns in Excel (5 Easiest Methods)
- Use Multiply Sign in Excel (With 3 Alternative Methods)
- How to Multiply a Column by a Number in Excel (4 Easy Methods)
- Multiply a Column in Excel by a Constant (4 Easy Ways)
- How to Multiply Two Columns and then Sum in Excel
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.
Read More: How to Multiply Multiple Cells in Excel (4 Methods)
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.
Read More: How to Multiply One Cell by Multiple Cells in Excel (4 Ways)
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.
Thanks for the tutorial, i find it very easy to understand and learn, many thanks for your effort
Hello, Bennie!
Thanks for your appreciation.
Regards
ExcelDemy