# Round off Formula in Excel Invoice (9 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to round off grand totals on your invoice using the excel formula. You will learn 13 different formulas to do that by following the article. If you need to do this for your grocery store or other businesses or other purposes then have quick look through this article.

## How to Round off Total on Invoice: 9 Excel Formula

Consider the following invoice. It contains some grocery items purchased by a customer. Here, the SUM function returns the subtotal of the total prices of all items. Now, if you want to round off the subtotal on the invoice then follow the methods below.

### 1. Use Excel ROUND Function to Round off the Total on Invoice

The ROUND function in excel rounds a number to a specified number of digits. Enter the following formula in cell F13 to get the desired result.

`=ROUND(SUM(F5:F10),1)` ### 2. Utilize Excel ROUNDUP Function

The ROUNDUP function in excel rounds a number up, away from zero. Now, apply the following formula in cell F13 to round the grand total up to 1 decimal place.

`=ROUNDUP(SUM(F5:F10),1)` Read More: How to Roundup a Formula Result in Excel

### 3. Round off Total with ROUNDDOWN Function

The ROUNDDOWN function in excel rounds a number down, toward zero. Now, enter the following formula in cell F13 to round the grad total down to 1 decimal place.

`=ROUNDDOWN(SUM(F5:F10),1)` Read More: How to Round Percentages in Excel

### 4. Use Excel MROUND Function

The MROUND Function in excel returns a number rounded to the desired multiple. Now, enter the following formula in cell F13 to get the rounded value of 1 time of the grand total.

`=MROUND(SUM(F5:F10),1)` ### 5. Use the INT Function

The INT function in excel rounds a number down to the nearest integer. Apply the following formula in cell F13 to get the desired result.

`=INT(SUM(F5:F10))` ### 6. Round off in Excel Invoice with TRUNC Function

The TRUNC function in excel removes the fractional part of a number and truncates it to an integer. Now, enter the following formula in cell F13 to get the desired result.

`=TRUNC(SUM(F5:F10),1)` Read More: Excel VBA: Round to Nearest 5

### 7. Use Formula with Excel CEILING Function to Round off Total

The CEILING function in excel rounds a number up to the nearest multiple of significance. Now, enter the following formula in cell F13 to round off numbers in Excel.

`=CEILING(SUM(F5:F10),1)` Read More: Rounding to Nearest Dollar in Excel

### 8. Apply Excel FLOOR Function

The FLOOR function in excel rounds a number down, to the nearest integer, or nearest multiple of significance. Now, enter the following formula in cell F13 to get the desired result.

`=FLOOR(SUM(F5:F10),1)` ### 9. Use the FIXED Function

The FIXED function in excel rounds a number to the specified number of decimals and returns the result as text with or without commas. Now, enter the following formula in cell F13 to get the desired result.

`=FIXED(SUM(F5:F10),1,TRUE)` Read More: Round to Nearest 5 or 9 in Excel

## Things to Remember

• You may need to press CTRL+SHIFT+Enter to enter the formulas. But if you are using Office365 then this won’t be necessary.
• The CEILING.PRECISE and the FLOOR.PRECISE functions are not visible on newer versions of excel. But you can type and enter the formula containing those functions.

## Conclusion

Now you know how to round off grand totals on your invoice using the excel formula. Please let us know if this article has helped you with that. You can also use the comment section below for further queries or suggestions. Do visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.

## Related Articles Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  