In the Number tab of the resulting menu click Percentage. Take the above data for example you can quickly find the percentage of a specific option with following formula. - which gives the result 125.
Enter an asterisk.
In cell B3 divide the second years sales 59863400 by the first year 48500000 and then subtract 1. Percentage of Total 1. Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B. Select the cell in which you entered 10.