Fresh Excel Tips

Today, we will be learning to use the the Excel built-in ROUND function to round a number to a specified number of digits. The syntax for this function is: ROUND(number, num_digits)
number: The number to be rounded.
num_digits: The number of digits that the specified number will be rounded to. If greater than 0, number is rounded to num_digits decimal places. If 0, number is rounded to the nearest integer. If less than 0, number is rounded to the left of the decimal point. Here is how to apply it in a formula. This will work in Excel 97, 2000, 2003 and 2007.

How to round numbers using the ROUND Function

1. In cells A2:A10 enter numbers with a decimal point.
2. In cells B2:B10 enter the number of decimal places the number should be rounded to.
3. Select cells C2:C10 and type the following formula: =ROUND($A2,$B2).
4. Press CTRL+Enter.

You should now be set.

1. How to Use the ROUNDDOWN function to round numbers down
2. How to Use the ROUNDUP function to round numbers up
3. How to Use the FIXED function to round and convert numbers
4. How to use the DOLLAR function to convert number to currency
5. How to Use the MROUND function to round prices to 5 or 25 cents