The examples in this section use the ROUND, ROUNDUP, and ROUNDDOWN functions. Significant digits are digits that contribute to the accuracy of a number. In some cases, you may want to use the EVEN and the ODD functions to round up to the nearest even or odd number. In the Decimal places box, enter the number of decimal places that you want to display. In the Category list, depending on the data type of your numbers, 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. To display more or fewer digits after the decimal point, on the Home tab, in the Number group, click Increase Decimal or Decrease Decimal. Select the cells that you want to format. Change the number of decimal places displayed without changing the number On a worksheet There are several ways to round a number. Or, you want to round a number to multiples of 10 to simplify an approximation of amounts. Let's say you want to round a number to the nearest whole number because decimal values are not significant to you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |