How to round up sums in Excel
In fact, very often accounting work requires rounding the money. When you use an automatic calculation formula, it doesn't always produce whole numbers. However, according to monetary rules: For example, Dong, the amount will be whole numbers without fractional parts. If you only use the number format to hide the decimal part, when you use the SUM function to sum the total will be skewed. For example, when you use the calculator to calculate the total VAT column = 150,386 + 1,283,040 + 50,696 = 1,484,122; but when you use the SUM function, the result is 1,484,123.
So today Dexterity Software will guide you how to round up the amount of money in Excel!
Use the ROUND function to round numbers
Function syntax: = ROUND (number, num_ditgits) .
Inside:
- ROUND: The function name used to round numbers.
- Number: The amount it needs to round.
- Num_ditgits: The section is rounded.
Note: The rule is that the ROUND function's rounding number is rounded off to less than 5, then rounding down. The part rounded to greater than or equal to 5 is rounded up.
If you want to round the whole decimal part when calculating in Excel software, Num_ditgits will be 0. With the above table example, when you calculate VAT, you use the additional ROUND function as follows: = ROUND (C5 * 0.1, 0).
If you want to round the thousandth, with the same ROUND formula, you change the value of Num_ditgits = - 3. So if the odd amount is less than VND 500, then round to zero. then round to 1000.
The same goes for other cases if you want to round the millionth, million in macro reports.
Use the ROUND function to round a decimal
Some currencies use the whole decimal part to represent value, typically the US Dollar is calculated into Cent.
For example, we have the conversion table from VND to USD as follows:
To ask you to round up to two decimal places of USD, you use the ROUND function with Num_ditgits = 2. And the result is as follows:
Good luck!
You should read it
May be interested
- How to list conditional lists in Excelhow to list conditional lists in excel. the lookup function is available in excel so that users can search by conditions but return only the first true value. if you need to list all the conditions and copy it to a different data sheet or another sheet ...
- How to use CONSOLIDATE to statistic, combine data in Excelconsolidate is one of excel's useful data statistics tools. consolidate allows you to quickly perform sum, average, maximum value, minimum value ... how to use consolidate to statistic and pool data in excel
- How to display formulas and print formulas in Exceldisplay formulas and print formulas in excel so you can see the formula directly in the data cell, not see the results anymore. to be able to display and print the formula so please follow the instructions below of tipsmake.com.
- How to lock Excel Sheet, set a password for the sheet in Excellock sheet, set password for data sheet in excel to create security for your data file, do not let anyone edit or add data. tipsmake.com will guide you how to do in our article below.
- Instructions on how to plot stacked columns in Exceldraw a stacked column chart in excel to represent data with images to give you a more intuitive look. in this article, tipsmake.com will guide you to create a stacked column chart in excel for an existing data table.
- How to count the number of occurrences of a character in Excelcounting the number of occurrences of a character in excel is a trick that requires you to use a combination of two different functions. to know how to combine this function, please follow the following article of tipsmake.com us.