The ROUND Formula in Excel accepts the following parameters and arguments: Number – The number which has to be rounded. Num_Digits – The total number of digits to round the number to. Return Value: The ROUND function returns a numeric value. Usage Notes
The ROUND in Excel follows the general math rules for rounding the numbers. In this ROUND function, the number to the right of the rounding digit will determine whether the number should be rounded upwards or downwards. The rounding digit is considered the least significant after the number is rounded. It also gets changed, depending on whether the digit following it is less or greater than 5.
Consider the following table to understand the above theory more deeply. In this ROUND in Excel example, we are taking the number 106.864. The position is cell number A2 in the spreadsheet.
How to Open the ROUND Function in Excel?
How to Use ROUND Function in Excel with ExamplesLet us look below at some examples of the ROUND formula in Excel. These examples will help you in exploring the use of the ROUND function. Based on the above Excel spreadsheet, let’s consider three examples and see the ROUND function return based on the syntax of the function. Example #1When the ROUND formula for Excel written is =ROUND (A1, 0) Result: 563 You can see the excel spreadsheet below – Example #2When the ROUND formula for Excel written is =ROUND (A1, 1) Result: 562.9 Consider the Excel spreadsheet below- Example #3When the ROUND formula for Excel written is =ROUND (A2, -1) Result: 60 Consider the Excel spreadsheet below – Example #4When the ROUND formula for Excel is written =ROUND (52.2, -1) Result: 50 You can consider the excel spreadsheet below – Example #5When the ROUND formula for Excel is written =ROUND (-24.57, 1) Result: -24.7 You can see the excel spreadsheet below – Other Rounding Functions in ExcelYou can also force Excel to always round a number up (away from zero) with the help of the ROUNDUP functionThe ROUNDUP excel function calculates the rounded value of the number to the upward side or the higher side. In other words, it rounds the number away from zero. Being an inbuilt function of Excel, it accepts two arguments–the “number” and the “num_of _digits.” For example, “=ROUNDUP(0.40,1)” returns 0.4. read more. If you want Excel to always round a number down (towards zero), use the ROUNDDOWN function in Excel. For specifying the multiple (example 0.5) that Excel uses to round, use the MROUND function in excelMROUND is the MATH & TRIGNOMETRY function in Excel, and it is used to round a number to the nearest multiple numbers. For example, =MROUND(50,7), will round the number 50 to 49.read more. Things to RememberROUND Excel Function VideoRecommended ArticlesThis article is a guide to ROUND Function in Excel. Here, we discuss the ROUND formula in Excel and how to use the Excel ROUND function, along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel: – |