Num_digits - the number of digits you want to round the number to. The ROUNDUP function rounds the number upward (away from 0) to a specified number of digits. The following screenshot demonstrates a few ROUND formula examples: If the rounding digit is followed by 5, 6, 7, 8, or 9, the rounding digit is increased by one, and the number is rounded up.If the digit to the right of the rounding digit is 0, 1, 2, 3, or 4, the rounding digit is not changed, and the number is said to be rounded down.Rounding digit is the last significant digit retained once the number is rounded, and it gets changed depending on whether the digit that follows it is greater or less than 5: The Excel ROUND function follows the general math rules for rounding, where the number to the right of the rounding digit determines whether the number is rounded upwards or downwards. If num_digits equals 0, the number is rounded to the nearest integer (no decimal places).įor example =ROUND(15.55,0) rounds 15.55 to 16.If num_digits is less than 0, all decimal places are removed and the number is rounded to the left of the decimal point (to the nearest ten, hundred, thousand, etc.).įor example =ROUND(15.55,-1) rounds 15.55 to the nearest 10 and returns 20 as the result.If num_digits is greater than 0, the number is rounded to the specified number of decimal places.įor example =ROUND(15.55,1) rounds 15.55 to 15.6.You can supply a positive or negative value in this argument: Num_digits - the number of digits to round the number to.
This can be a number, reference to a cell containing the number or a formula-driven value. Number - any real number you want to round. ROUND is the major rounding function in Excel that rounds a numeric value to a specified number of digits.
ODD - round the number up to the nearest odd integer. EVEN - round the number up to the nearest even integer. TRUNC - truncate the number to a specified number of decimal places. INT - round the number down to the nearest integer. CEILING - round the number up to the specified multiple. FLOOR - round the number down to the specified multiple. MROUND - rounds the number upward or downward to the specified multiple. ROUNDDOWN - round the number downward to the specified number of digits. ROUNDUP - round the number upward to the specified number of digits. ROUND - round the number to the specified number of digits. Unlike formatting options that change only the display value, Excel round functions alter the actual value in a cell.īelow you will find a list of functions specially designed for performing different types of rounding in Excel. If you refer to that cell in any formulas, the original non-round value will be used in all calculations. Important note! This method changes the display format without changing the actual value stored in a cell. Click the OK button to save the changes and close the Format Cells dialog. A preview of the rounded number will immediately show up under Sample. In the Format Cells window, switch to either Number or Currency tab, and type the number of decimal places you want to display in the Decimal paces box. Open the Format Cells dialog by pressing Ctrl + 1 or right click the cell(s) and choose Format Cells. Select the cell with the number(s) you want to round. If you want to round numbers in Excel solely for presentations purposes, you can change the cell's format by performing the following steps: Excel round a date up to the first of the month how to#
How to round to nearest 5/10/100/1000 etc.Įxcel rounding by changing the cell format. Extracting a fractional part of a decimal. Rounding decimals to a certain number of places. Below, you will find a quick overview of the major round functions and well as formula examples that demonstrate how to use those functions on the real-life data in your worksheets. And Microsoft Excel provides a handful of functions to handle different rounding types. Many different ways of rounding exist, such as rounding to integer, rounding to a specified increment, rounding to simple fractions, and so on. For instance, you can use rounding to make long decimal numbers shorter to report the results of complex calculations or round off currency values. In everyday life, rounding is commonly used to make numbers easier to estimate, communicate or work with. In other words, rounding lets you get an approximate number with the desired level of accuracy. In plain English, to round a number is to eliminate the least significant digits, making it simpler but keeping close to the original value. 
In some situations when you don't need an exact answer, rounding is a useful skill to use.
The tutorial explains the uses of ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING, MROUND and other Excel rounding functions and provides formula examples to round decimal numbers to integers or to a certain number of decimal places, extract a fractional part, round to nearest 5, 10 or 100, and more.
0 kommentar(er)
