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.


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.

Use ROUND Function to Round a Multiplication Formula in Excel

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.

Use ROUND Function to Round a Multiplication Formula in Excel

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.

Insert ROUNDUP Function to Round a Multiplication Formula in Excel

  • Then to get the other outputs, use the Fill Handle tool.

Insert ROUNDUP Function to Round a Multiplication Formula in Excel

Output after using the Fill Handle tool.

Read More: If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)


Similar Readings


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.

Use ROUNDDOWN Function in Excel to Round a Multiplication Formula

  • Finally, use the Fill Handle tool to finish.

Use ROUNDDOWN Function in Excel to Round a Multiplication Formula

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.

Use MROUND Function to Round a Multiplication Formula in Excel

  • After that, drag down the Fill Handle icon to copy the formula.

Use MROUND Function to Round a Multiplication Formula in Excel

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.

Apply INT Function in Excel to Round a Multiplication Formula

  • Lastly, use the Fill handle icon over the cells E6:E9 to copy the formula.

Apply INT Function in Excel to Round a Multiplication 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.


Related Articles

Md. Sourov Hossain Mithun
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.

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo