Round off Formula in Excel Invoice (9 Quick Methods)

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)

Round off the Total on the Invoice with Excel ROUND Function

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)

Round off the Total on the Invoice with Excel MROUND Function

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)

Round off the Total on the Invoice with Excel TRUNC Function

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)

Round off the Total on the Invoice with Excel CEILING Function

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)

Round off the Total on the Invoice with Excel FLOOR Function

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.


Related Articles

Md. Shamim Reza

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

Leave a reply

ExcelDemy
Logo