How To Use Excel Round Function

Select ok to complete the formula and return to the worksheet.

How to use excel round function. The round function returns a numeric value. To round down to the nearest specified multiple use the floor function. Except in excel for mac where you select done instead. This function rounds numbers to the nearest decimal based on your specified number of digits. Type a 2 to round the answer to the sum function to 2 decimal places.

You can use the round function in excel for rounding numbers to a specified level of precision. The round formula in excel works by rounding the numbers 1 4 down and rounding the numbers 5 9 up. The round function rounds a number to a specified number of digits. For example the function round 1234 4321 2 rounds the number to 1200. 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.

If the next digit to the right is 0 1 2 3 or 4 it rounds down. Here in c2 cell the number will be rounded down to 1 decimal place as 3 comes in 1 4. To round normally use the round function. To round to the nearest multiple use the mround function. Significance the multiple to which you wish to round the number.

Round can be used for rounding to the right or left of the decimal point. So 7 82564 rounded to two decimal places would become 7 83. To round normally use the round function. If the next digit to the right is 5 6 7 8 or 9 it rounds up. Round a1 2 the result of this function is 23 78.

Copy the formula using ctrl d taking the first cell till the last cell needed formula. The answer 764 87 appears in cell b6 since the sum of the data in cells d1 to d3 764 8653 is rounded to 2 decimal places. When excel uses the round function to round numbers it follows conventional rounding rules. After clicking on round function it will open a pop up for function arguments. As you can see the result.