How to calculate or get percentage of total in Excel. To calculate the percentage of a total in Excel execute the following steps. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula.
To use the format 92 that is one decimal place instead of 9 choose the Increase Decimal icon.
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. Excel offers us multiple configuration options. The basic formula for calculating a percentage is parttotal. The running total calculation sums all of the values in a column from the current row the formula is in to the first row in the data set.