The second argument is the number of digits you want to round the number to. The first argument is the number you want to round, which can be a cell reference or a number. This function has only two arguments (arguments are pieces of data the formula needs to run). Round a number to the number of digits you want by using the ROUND function. In the Decimal places box, enter the number of decimal places that you want to display. In the Category list, depending on the type of data you have, click Currency, Accounting, Percentage, or Scientific. On the Home tab, in the Number group, click the arrow next to the list of number formats, and then click More Number Formats. On the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.
Select the cells that you want to format. If you want to round a number to the nearest major unit, such as thousands, hundreds, tens, or ones, use a function in a formula, follow these steps:
If you don’t want unnecessary decimal places in cells because they cause # symbols to appear, or you don’t need accuracy down to the microscopic level, change the cell format to get the number of decimal places you want.
0 kommentar(er)
