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.

**Table of Contents**hide

**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