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.
Get percentage of total. If you need to calculate percent of a total (i.e. calculate a percent distribution), you can do so with a formula that simply divides the amount by the total. Note that you must format the result using the Percentage number format in Excel.ote that the reference to C11 is absolute (i.e. $C$11) so that the reference won't change when the formula is coped down the column. As always in Excel, when you want to display a percentage, you need to use the Percentage number format, which will automatically display a decimal value as a percentage.