How to round up sums in Excel

How to round up sums in Excel Picture 1

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.

How to round up sums in Excel Picture 2

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:

  1. ROUND: The function name used to round numbers.
  2. Number: The amount it needs to round.
  3. 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).

How to round up sums in Excel Picture 3

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.

How to round up sums in Excel Picture 4

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:

How to round up sums in Excel Picture 5

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:

How to round up sums in Excel Picture 6

Good luck!

5 ★ | 2 Vote

May be interested

  • MS Excel 2007 - Lesson 2: Customizing in ExcelMS Excel 2007 - Lesson 2: Customizing in Excel
    excel 2007 provides a wide range of customizable options, allowing you to work with excel in the most convenient way.
  • 3 ways down the line in Excel, line break, down row in 1 Excel cell3 ways down the line in Excel, line break, down row in 1 Excel cell
    there will be 3 ways downstream in excel, suitable for each case of content entry. please follow the downstream instructions in excel below for details.
  • Shortcut guide, abbreviated in ExcelShortcut guide, abbreviated in Excel
    the autocorrect feature in excel is a shorthand feature, which shuts down frequently written words that appear in content, without rewriting many times.
  • Microsoft Excel test P5Microsoft Excel test P5
    in the article below, network administrator will send you more useful information about excel software through the following quiz. let's see how much you know about excel.
  • How to fix the insertion block in ExcelHow to fix the insertion block in Excel
    inserting shape shapes into excel is very simple. so how to fix the inserted shapes into excel?
  • Test Microsoft Excel P16Test Microsoft Excel P16
    when using an application regularly, you will often get used to it and handle it faster. are you confident enough about your ability to use excel? try a little test to measure your excel proficiency!
  • Summary of expensive shortcuts in Microsoft ExcelSummary of expensive shortcuts in Microsoft Excel
    in the work, especially when you have to perform many calculations, the formula in microsoft excel documents, the use of the mouse is strictly tortuous. not wrong, because when you master the formulas, shortcut keys on excel, using the keyboard will be fast and convenient a lot.
  • How to disable Hyperlink in ExcelHow to disable Hyperlink in Excel
    when you want to copy a certain line of text in excel, you have hyperlink. if the link is contained, when we check the text, we will access the inserted web page. so how to do it?
  • Complete tutorial of Excel 2016 (Part 5): Basics of cells and rangesComplete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
    whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the basics of cells and cell contents to calculate, analyze, and organize data in excel.
  • How to use subtraction in ExcelHow to use subtraction in Excel
    subtraction in excel is a basic calculation, which is used a lot in excel calculation exercises.