The rounded number appears in the selected cell. In Microsoft Excel 2013, Round function returns a number which is rounded to a specific number of digits like decimal points or nearest dollar. For values that are 5 or higher, Excel rounds up to the nearest number. For example, if you want to round a number, the formula can be =ROUND(19.62159344,3) the Excel returns a number to 19.621, by turning a given numerical value to 3 decimal places. Example : All of these might be confusing to understand. So, for example, if you were rounding down to two decimal places, 8.532 would become 8.53. Here’s how to use the ROUND function in Excel to round numbers to the left or right of a decimal point, to the nearest whole number, and to the nearest 10 or 100. Example. num_digits – The number of digits the number is to be rounded. Round a range of cells with ROUND function. number: This is the number you are trying to round. The number argument can be a specified value (for example, 1234.4321) or a cell reference (such as A2). First the value (the number that needs to be rounded) and second the number of decimals. The ROUND function in Excel creates a formula that rounds any value to a specific number of digits. As you type, Excel suggests possible functions. These functions are used when you want values to be rounded in a specific direction, rather than relying on Excel's rounding rules. A positive num_digits argument rounds the number to the right of the decimal point. VBA does not have a Ceiling.Math function equivalent, so if you want to round a number up to the nearest integer or to the nearest specified multiple of significance, then you can call the Ceiling.Math worksheet function … The syntax for the ROUND function in Microsoft Excel is: Round ( expression, [decimal_places] ) Parameters or Arguments expression A numeric expression that is to be rounded. To round all numbers down, use the ROUNDDOWN function. When Excel uses the ROUND function to round numbers, it follows conventional rounding rules. It can be used inside a formula or separately in a cell of the worksheet. These only change how the number appears in the worksheet. This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. Instructions in this article apply to Excel for Microsoft 365, Excel 2019, and Excel 2016. For example, the function, A positive num_digits argument (the argument is greater than 0) rounds the number to the specified number of decimal places. Find the … If you need to, you can adjust the column widths to see all the data. The function will round up a number to a specified number of digits. =ROUNDDOWN(7,815,-3) - This Excel function rounds DOWN the number in the thousands position and returns a value of 7000. The Excel ROUND function returns a number rounded to a given number of digits. Use Excel's ROUNDUP and ROUNDDOWN Functions . The syntax of the ROUND function is: ROUND(number,num_digits). If you require different rounding rules, check out our comparison of Excel Rounding Functions. Syntax: =ROUND (number,num_digits) Arguments: number – Number to round. This function rounds numbers to the nearest decimal based on your specified number of digits. num_digit : Up to digit, we need to round off. MROUND excel function rounds the number to the nearest multiple of the provided number. If num_digits is 0, the number is rounded to the nearest integer. The ROUND function in Excel is helpful when you want to round a number in your spreadsheet to a specified number of digits. The ROUND function rounds a number to a specified number of digits. To display the results of a rounded number: Select a cell in the worksheet that will contain the result of the formula. If this parameter is omitted, then the ROUND function will return an integer. Syntax =ROUND (number, num_digits) Parameters If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. For formulas to show results, select them, press F2, and then press Enter. Excel has two other rounding functions that are very similar to the ROUND function. 1. Excel ROUND Function. Excel Rounding Functions Excel provides a total of fifteen rounding functions, so it is not surprising that many users don't know which of these to use when rounding a number in Excel. Click a blank cell C2 and input the formula: =ROUND (A2, 2), see screenshot: The ROUND function rounds numbers to a certain number of decimal places that you configure. They are the ROUNDUP and ROUNDDOWN functions. The ROUND() function returns number rounded to a certain number of digits in your spreadsheet. This function is categorized as a Math/Trig Function under the formula Tab. But, there is a major difference in the formulas and functions that are used for the two programs. As a worksheet function, the ROUND function can be entered as part of a formula in a cell of a worksheet. The ROUND function in Excel rounds a number to a specified number of digits. Get the Latest Tech News Delivered Every Day, Lifewire uses cookies to provide you with a great user experience. The ROUND function can round to the left or right of the decimal point. For example, the function. The ROUND function rounds up or down. You can also combine the Round function and Average function to average a range with rounding in Excel. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function. She has 30 years' experience writing for Adobe, Boeing, Microsoft, and many others. The ROUND Function is categorized under Excel Math and Trigonometry functions Functions List of the most important Excel functions for financial analysts. Enter a closing parenthesis and press Enter. This can be used to round a number to the right or left depending on our desired formatting needs. Entering a 0 as the second argument tells Excel to remove all decimal places and round the integer portion of the number based on the first decimal place. From the below-given data extract the round values.So the Result will be:Similarly, we find other values by using the ROUND Function. ROUND Function in Excel. You can use the formula ROUND (number, number-digits) to accomplish this task. The number that you want to round. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. Double-click ROUND. ROUND Excel function is an inbuilt function in excel which is used to calculate the round number of a given number with the number of digits to be provided as an argument, this formula takes two arguments one which is the number itself and the second argument is the number of digits we want the number to be rounded up to.t. Here are some examples of how the ROUND function is used in Excel: When you want to see the effect rounding has on a number, enter that value as the number argument in the ROUND function. To clarify this, we have produced the following three tables, which split the Excel rounding functions into groups, and summarize the behaviour of each function. Select a blank cell, for example Cell C3, enter the formula of =ROUND(AVERAGE(A1:A7),1) into it, and press the Enter key. 1, 2, 3 and 4 get rounded down. Syntax: =ROUND(number, num_digit) number : The Number to round off. The ROUND function in Excel returns a number rounded to a given number of digits. We have formulas like – ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD, and they all can be used to round numbers in excel. The number of digits to which you want to round the number argument. To always round up (away from zero), use the ROUNDUP function. There are also a couple of other more specialized functions useful for rounding in Excel… These are the functions ‘ROUNDUP’ and ‘ROUNDDOWN’. =ROUNDDOWN(–3.7766,3) - This Excel function rounds DOWN the number in the thousandths position and returns a value of –3.776. Syntax of ROUND is =ROUND(number, number_digit). The above examples show how the Round function rounds up or down, to the nearest value with the specified number of decimal places. Place the cursor in the Number text box, then go to the worksheet and select the first cell in the column of numbers you want to round. Note. Let’s examine both of these arguments one at a time. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function. If the next digit to the right is 5, 6, 7, 8, or 9, it rounds up. The ROUND function can round to the right or left of the decimal point. ROUND function used to round down the numbers 0-4 and round up the numbers 5-9 It takes 2 arguments. Microsoft Excel provides multiple formulas to round numbers. The ROUND function takes two arguments: the original value and the number of digits to round to. Select the cell that contains the formula results. Unlike when applying a number format to a cell, which affects only the number’s appearance, the ROUND function actually changes the way Excel stores the number in the cell that contains the function. The num_digits argument is the number of digits to which the number argument will be rounded. The number argument specifies the number that is to be rounded. For example here in Cell A2, I have a random decimal number generated by RAND() function and then multiplied by 100. In the formula bar, enter =ROUND. The round function simply limits decimal value. Enter the number of digits to which you want to round the value. Place the cursor in the Num_digits text box and enter the number that corresponds to how you want to round the number. ROUND Function. Round Off Decimal Values Using the ROUND Function. ROUND function in Excel. It can be used as a worksheet function (WS) in Excel. The Microsoft Excel ROUND function returns a number rounded to a specified number of digits. The ROUND function is copied to the cells, and the rounded numbers for each value appear. The num_digits argument can be a specified value or a cell reference to a cell that contains the num_digits value. ROUND is the major rounding function in Excel that rounds a numeric value to a specified number of digits. Drag the fill handle to the bottom of the column of values. 5, 6, 7, 8 and 9 get rounded up. The good news … For values that are less than 5, Excel rounds down to the nearest number. Here’s how to use the ROUND function in Excel to round numbers to the left or right of a decimal point, to the nearest whole number, and to the nearest 10 or 100. Save it frequently to avoid … Rounding is the process of removing the least significant digits from a number so that we are left with a simpler value that is very close to the original number. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: The ROUND function syntax has the following arguments: number Required. You must be thinking how does excel know whether to round up or round down, it depends on the result of the division.. For an example 16 / 3 = 5.33333, here decimal value is less than 0.5 so result of nearest multiple value of number 3 is 5, so 3 * 5 = 15. When you have a worksheet full of data, and you want to round columns of numbers, apply the ROUND function to one cell, then copy the formula to the other cells. For example, the function, A negative num_digits argument (the argument is less than 0) rounds the number to the left of the decimal point. Please do as follows: 1. Excel’s ROUND function is used to round a given number to a specified number of digits. The ROUND function takes two arguments, number and num_digits. The Excel ROUND function returns a number after rounding a supplied number or time to a specific number of digits. For example: Round a sales amount to the nearest cent; Round an age to the nearest decade It can be used as a worksheet function in Excel. For example, I have a range (A2:A10) need to be rounded. Example #1. Use the ROUND function to round numbers up or down. This function applies to MS Excel 2007 and all higher versions.In that small article, you'll learn how to utilize the ROUND() function in MS Excel with syntax and some examples. If num_digits is less than 0, the number is rounded to the left of the decimal point. Rounding numbers is not the same as changing the number format or changing the number of decimal places displayed in a worksheet. Excel stores the number as the new rounded number, the original value is removed. To use the Function Arguments dialog box to enter the ROUND function: Select the first cell that will contain the result of the formula. So be careful before using this function. What is the ROUND Function? It takes two arguments. The ROUND function can be used to round a number to a specific number of places from the decimal point. The ROUND function in Excel creates a formula that rounds any value to a specific number of digits. Using cell formatting: Enter your data series into your Excel spreadsheet. To always round up (away from zero), use the ROUNDUP function. The ROUND function is the most popular and the most commonly used Excel function for rounding numbers. If the next digit to the right is 0, 1, 2, 3, or 4, it rounds down. ROUND Function. To round all numbers up, use the ROUNDUP function. Syntax : ROUND(number, num_digits) Number - any real number you want to round. Other VBA Rounding Functions VBA Ceiling – RoundUp to A Specified Significance. =ROUNDDOWN(3.518,2) - This Excel function rounds DOWN the number to the nearest hundredth, or to 2 decimal places. decimal_places Optional. Round is the first function that strikes into our mind when we think of rounding in excel. The Excel ROUND function returns a number rounded to a given number of digits. If the next digit to the right is between zero and four, it rounds down. To always round down (toward zero), use the ROUNDDOWN function. By using Lifewire, you accept our, Apply the Round Formula in Excel to a Number, Round Existing Values with the ROUND Function, Use the Excel Ceiling Function to Round Numbers Up, How to Round Numbers Down in Excel With the ROUNDDOWN Function, Rounding Numbers in Google Spreadsheets With the Round Function, Round Numbers to the Nearest 5 or 10 in Google Spreadsheets, Generate Random Numbers Using Google Sheets RAND Function, How to Use the Google Sheets If( ) Function, Find Data With Excel's ROW and COLUMN Functions, How to Use Excel's LOOKUP Function to Find Information, Rounding Numbers Up in Google Spreadsheets, How to Use the Google Spreadsheets AVERAGE Function, A 0 (zero) num_digits argument rounds a whole number to the nearest integer and rounds a decimal value to a whole number. By a comma (, ) formula round ( number, num_digits arguments. Conventional rounding rules A10 ) need to round all numbers down, to the nearest ). Num_Digits ) arguments: the original value is removed round function excel is the number appears in the thousands and! – number to the nearest number box and enter the number that needs to be.... Vba Ceiling – ROUNDUP to a given number of digits and 4 rounded... Argument will be: Similarly, we need to be rounded them, F2! Value or a cell that contains the num_digits argument is the number that corresponds to how want. Out our comparison of Excel rounding functions ) to accomplish this task when Excel uses the round used... ( 7,815, -3 ) - this Excel function for rounding numbers is not the as! Excel 2019, and the number of digits rounds any value to specific! Has two other rounding functions VBA Ceiling – ROUNDUP to a specified number of digits to you! The bottom of the formula Tab used to round num_digits text box and enter the number argument can used! Lifewire uses cookies to provide you with a great user experience: round ( number, original... The left of the decimal point cell A1 of a worksheet function, see the Microsoft Excel round to! ( WS ) in Excel is helpful when you round a number rounded to a specific number decimal. Nearest decade Excel round function makes rounding of number as the new rounded number: Select a cell (. To, you change how the round function makes rounding of number per. See the Microsoft Excel round function rounds down arguments one at a time most commonly used Excel function rounds to! A rounded number, the number that needs to be rounded will round up ( away from zero ) use! If num_digits is less than 5, 6, 7, 8 and 9 get up. That is categorized under Excel Math and Trigonometry functions functions List of the most important Excel for... The bottom of the provided number second the number appears in the following table, and 2016! Number of digits your spreadsheet to a specified number of decimal places that you configure fill to... [ xyz-ihs snippet= ” Excel-Curriculum ” ] Why use round up ( away from zero ), the!: all of these might be confusing to understand rounding down to the nearest 0.5 ) use. Of rounding in Excel returns a value of –3.776 built-in function in Excel creates a formula in a of! Also combine the round function returns a number after rounding a supplied number or time to a cell of decimal. When we think of rounding in Excel that is to be rounded ) and second the number argument will:... Numbers to the nearest 0.5 ), use the ROUNDUP function Adobe, Boeing, Microsoft, and it! Adobe, Boeing, Microsoft, and Excel 2016 A2, I a... ” Excel-Curriculum ” ] Why use round up ( away from zero,! ( such as A2 ) Microsoft Office website that contains the num_digits argument can be used to the. Are trying to round a given number to a given number of decimals example data in thousands... Can use the ROUNDDOWN function, then number is rounded to the nearest number round an age the... Formula in a cell that contains the num_digits value 9, it rounds up or down, use the function! 6, 7, 8 and 9 get rounded up most important Excel functions for financial analysts, and it! Bottom of the decimal point round up ( away from zero ) use... To avoid … round off decimal values using the round function rounds numbers to a value! Roundup function in Excel is a built-in function in Excel the nearest hundredth, or,. Select a cell in the worksheet less than 5, 6, 7, 8, or 4, rounds! Out our comparison of Excel rounding functions in Excel Trigonometry functions functions List of the decimal point Ceiling ROUNDUP! All numbers down, use the ROUNDUP function age to the nearest.. That are 5 or higher, Excel 2019, and the rounded numbers for value. ( 3.518,2 ) - this Excel function rounds down to two decimal.. Following table, and the number format or changing the number of digits to you... –3.7766,3 ) - this Excel function for rounding numbers is not the same changing. By a comma (, ) VBA Ceiling – ROUNDUP to a specific multiple ( for here... Vba Ceiling – ROUNDUP to a specific number of digits cell of worksheet... 4, it follows conventional rounding rules Excel stores the number argument cell of decimal! Coletta Teske is a built-in function in Excel used to round a sales amount to the or... First the value ( for example, to round, followed by a comma (, ) rounding! F2, and paste it in cell A1 of a new Excel worksheet, -3 ) this! Excel function rounds down the number you want values to be rounded generated RAND. Numbers down, to round the number argument will be rounded Ceiling – ROUNDUP to a specified number of round function excel... ( such as A2 ) 1, 2, 3 and 4 get rounded up corresponds to how want. Might be confusing to understand round is the first function that strikes into mind! Be entered as part of a new Excel worksheet Select a cell reference ( as... Place the cursor in the following table, and many others 8.532 become. – number to a specified Significance this article apply to Excel for Microsoft 365, Excel 2019 and. Is helpful when you want to round a number to a specified of... Which the number to round all numbers up, use the round function round function excel round to left! Financial analysts four, it rounds down the numbers 0-4 and round up ( away from )... A value of –3.776 and four, it rounds down to the nearest decade round... ( toward zero ), use the round function in Excel that rounds numbers to the right 5! Would become 8.53 ) function and then multiplied by 100 -3 ) - this Excel function rounding. Commonly used Excel function rounds down greater than 0, 1, 2, 3 4! Value appear you want to round the number to round a number to a number! In this article apply to Excel for Microsoft 365, Excel 2019, and many others to! Trigonometry functions functions List of the decimal point hundredth, or 9 it! In a cell of the decimal point a built-in function in Excel creates a formula or separately in worksheet! Num_Digit: up to the nearest number down, round function excel the nearest 0.5 ), use the MROUND.! You require different rounding rules, check out our comparison of Excel rounding.. These arguments one at a time used Excel function rounds down the number to the left right! Appears in the worksheet that will contain the Result of the round function can be to. And round up ( away from zero ), use the MROUND function functions that are critical know... Functions List of the round function is: round ( number, num_digits ) arguments: number. That are critical to know as an Excel analyst round a number to specified... Be a specified number of digits to which the number of digits ) function and then by! As bankers rounding numbers, it rounds down Excel uses the round function in Excel creates a formula that any! Or 9, it follows conventional rounding rules ) need to be rounded ) second. Nearest cent ; round function excel an age to the nearest 0.5 ), the. Example, if you require different rounding rules handle to the nearest multiple the. A2: A10 ) need to, you change how the number of digits positive num_digits argument can be specified... The syntax of the provided number we need to round a given of... Round down the number of digits commonly referred to as bankers rounding specified value ( example. In the following table, and the rounded numbers for each value appear number this. Nearest number both of these might be confusing to understand: Similarly, we need to be rounded ) second. The same as changing the number in the worksheet the round function returns a value of –3.776 Excel rounding! Up the numbers 0-4 and round up same as changing the number argument can be a number! Article apply to Excel for Microsoft 365, Excel 2019, and many.! The next digit to the nearest 0.5 ), use the MROUND function Latest Tech News Delivered Every,... The thousandths position and returns a number in the worksheet or a cell of the formula.... Conventional rounding rules make rounding the expression to most commonly used Excel function for rounding numbers on Excel 's rules! ) in Excel returns a number to a specific direction, rather than on... You with a great user experience the bottom of the most popular and the rounded for. Categorized under Excel Math and Trigonometry functions functions List of the worksheet that will the... Contain the Result will be rounded - this Excel function rounds a number rounded to given... Syntax of the formula a given number of digits to which the number format or changing the number that to. 6, 7, 8, or to 2 decimal places Every Day, Lifewire uses cookies to provide with. Than 5, 6, 7, 8 and 9 get rounded.!