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

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-

• 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–

• 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–

• 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–

• 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–

• 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.

Related Articles

• How to Multiply from Different Sheets in Excel (5 Methods)
• Divide and Multiply in One Excel Formula (4 Ways)
• How to Make Multiplication Table in Excel (4 Methods)
  
• Multiply Rows in Excel (4 Easiest Ways)
• How to Multiply Columns in Excel (9 Useful and Easy Ways)