How To Use Excel Round Function

You can use the round function in excel for rounding numbers to a specified level of precision.

How to use excel round function. Significance the multiple to which you wish to round the number. Rounding functions in excel. As you can see the result. Round a1 2 the result of this function is 23 78. To round normally use the round function.

Round can be used for rounding to the right or left of the decimal point. The round function returns a numeric value. 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. If the next digit to the right is 5 6 7 8 or 9 it rounds up.

Here in c2 cell the number will be rounded down to 1 decimal place as 3 comes in 1 4. Rounding functions in excel. This function rounds numbers to the nearest decimal based on your specified number of digits. Select round function from the above drop down menu list. When excel uses the round function to round numbers it follows conventional rounding rules.

As you can see 2 3 is rounded down to 1 decimal place. 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. Under number field enter a number which needs to be round. To round down to the nearest specified multiple use the floor function. For values that are less than 5 excel rounds down to the nearest number.

For example the function round 1234 4321 2 rounds the number to 1200. To round up to the nearest specified place use the roundup function. Select ok to complete the formula and return to the worksheet. Floor number significance number the number you want to round. To round to the nearest multiple use the mround function.