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.
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)
Read More: How to Round Excel Data to Make Summations Correct
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)
Read More: How to Add ROUND Formula to Multiple Cells in Excel
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
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)
Read More: How to Round to Nearest 10 Cents in Excel
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.
Download Practice Workbook
You can download the practice workbook from the download button below.
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
- How to Set Decimal Places in Excel with Formula
- How to Round Numbers to the Nearest Multiple of 5 in Excel
- Round Down to Nearest 10 in Excel
- How to Round to Nearest 100 in Excel
- How to Round Numbers to Nearest 10000 in Excel
- How to Round a Formula with SUM in Excel
- How to Round up Decimals in Excel
- How to Round Up to 2 Decimal Places in Excel
- How to Get 2 Decimal Places Without Rounding in Excel
- How to Set Rounding Precision in Excel
- How to Round Time in Excel
- How to Round Time to Nearest Minute in Excel
- Round Time to Nearest 5 Minutes in Excel
- How to Round Time to Nearest 15 Minutes in Excel
- Rounding Time in Excel to Nearest Hour
- Rounding Time to Nearest Quarter Hour in Excel
- How to Round Off to Nearest 50 Cents in Excel
- How to Stop Rounding in Excel
- How to Stop Excel from Rounding Large Numbers
- How to Remove Decimals without Rounding in Excel
- How to Stop Excel from Rounding Up Decimals
- How to Round a Multiplication Formula in Excel
- How to Round Numbers in Excel Without Formula
