The formula to calculate percentage is equal to the ratio of the actual value to the total value multiplied by 100. Convert 10 to a decimal by removing the percent sign and dividing by 100. Hence the percentage means a part per hundred.
Calculating percentage increase is as simple as dividing the size of the increase by the original amount.
First click into cell D2 so the percentage shows up in the Percentage column. We dont have any specific excel percentage formula and it is not required as per me and MS apparently. Now to calculate the percentage we have to know its formula. Take an example if you had 10 strawberries and you ate 2 then you have consumed 20 percent of strawberries out of all and left with 80 percent of the things.