AT Museum manager Joe EarthTone Harold did an informal social media survey of hikers earlier this year, to learn about the sources of trail names on the Appalachian. Of 223 respondents, 77% said they had a trail name. Of these, 80% had been given their name and 20% chose their own.
When creating a formula that should return a percentage value, you will need to format the field correctly to get the % sign to properly show. Right-click on the field in question, select Format Field. Click the Display Currency Symbol checkbox. Click the Customize button. Click the Currency Symbol tab.
Type =(B1-A1)/A1 in cell C1, and press Enter to calculate the increase in decimal format. Step 4. Click the cell again, and then click the percent sign in the Home tab's Number group to format it as a percentage. Alternatively, press Ctrl-Shift-5 to apply the format.dd 100 to the percentage, and enter the total in cell B1. Be sure to include the percent sign after the figure so Excel recognizes it as a percentage. As an example, you might enter 150% for a 50 percent markup or 110 to add a 10 percent sales tax. Step 3.