Example 1: Increase or decrease a number by a percentage This section shows several simple techniques for calculating percentages. Top of Page Examples of calculating percentages For more information about conditional formatting, see Add, change, find, or clear conditional formats. This particular rule instructs Excel to apply a format (red text) to a cell if the cell value is less than zero. The conditional formatting rule you create should be similar to the one shown in the following example. You can also use conditional formatting ( Home tab, Styles group, Conditional Formatting) to customize the way negative percentages appear in your workbook. For more information about how to create custom formats, see Create or delete a custom number format. Similarly, you can display negative percentages in parentheses by creating a custom format that resembles this one: 0.00%_) (0.00%). The portion that follows the semicolon represents the format that is applied to a negative value. When applied to cells, this format displays positive percentages in the default text color and negative percentages in red. The format should resemble the following: 0.00% -0.00%. If you want negative percentages to stand out-for example, you want them to appear in red-you can create a custom number format ( Format Cells dialog box, Number tab, Custom category). Cells that are formatted with the General format have no specific number format. To reset the number format of selected cells, click General in the Category list. Top of Page Tips for displaying percentages For example, if you want to see 10% instead of 10.00%, enter 0 in the Decimal places box. In the Decimal places box, enter the number of decimal places that you want to display. In the Format Cells dialog box, in the Category list, click Percentage. On the Home tab, in the Number group, click the icon next to Number to display the Format Cells dialog box. If you want more control over the format, or you want to change other aspects of formatting for your selection, you can follow these steps. To quickly apply percentage formatting to selected cells, click Percent Style in the Number group on the Home tab, or press Ctrl+Shift+%. Top of Page Display numbers as percentages (If you don't want to display the two zeros after the decimal point, it's easy to get rid of them, as explained in the following procedure.) For example, typing 10 or 0.1 both result in 10.00%. Numbers equal to and larger than 1 are converted to percentages by default and numbers smaller than 1 are multiplied by 100 to convert them to percentages. To learn more about calculating percentages, see Examples of calculating percentages.įormatting empty cells If you apply the Percentage format to cells, and then type numbers into those cells, the behavior is different. If you then format 0.1 as a percentage, the number will be correctly displayed as 10%. For example, if a cell contains the formula =10/100, the result of that calculation is 0.1. Percentages are calculated by using the equation amount / total = percentage. To accurately display percentages, before you format the numbers as a percentage, make sure that they have been calculated as percentages, and that they are displayed in decimal format. For example, if a cell contains the number 10, Excel multiplies that number by 100, which means that you will see 1000.00% after you apply the Percentage format. In this articleĮxample 1: Increase or decrease a number by a percentageĮxample 2: Calculate an amount based on a percentageĮxample 3: Calculate the percentage based on two amountsĮxample 4: Calculate an amount based another amount and a percentageĮxample 5: Calculate the difference between two numbers and show it as a percentageĪlthough formatting numbers as percentages is straightforward, the results you get after you apply the format may vary, depending on whether the numbers already exist in your workbook.įormatting cells that already contain numbers If you apply the Percentage format to existing numbers in a workbook, Excel multiplies those numbers by 100 to convert them to percentages. Learn how to display numbers as percentages in Excel and view examples of several basic techniques for calculating percentages in your worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |