Md. Shamim Reza
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.
Download Practice Workbook
You can download the practice workbook from the download button below.
9 Excel Formula to Round off Total on Invoice
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)
Read More: How to Round Excel Data to Make Summations Correct (7 Easy Methods)
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 (4 Easy Methods)
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 Simple Methods)
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)
Read More: How to Add ROUND Formula to Multiple Cells in Excel (2 Easy Ways)
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))
Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)
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 (Macro and UDF)
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 (6 Easy Ways)
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)
Read More: How to Round to Nearest 10 Cents in Excel (4 Suitable Methods)
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 (8 Easy Methods)
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.
