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)

Round off the Total on the Invoice with Excel ROUND Function

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)

Round off the Total on the Invoice with Excel MROUND Function

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


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)

Round off the Total on the Invoice with Excel TRUNC Function


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)

Round off the Total on the Invoice with Excel CEILING Function


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)

Round off the Total on the Invoice with Excel FLOOR Function


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)


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


<< Go Back to Rounding in Excel | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo