How to find the percentage of a total Enter the total goal into one cell. 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. This formula divides the value in cell A1 by the value in cell B1.
On the Home tab in the Number group click the percentage symbol to apply a Percentage format.
The basic formula to do this is Part Whole Percent You then format the cell as a percent. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. As an office automation tool it allows thousands of calculations to be made in just minutes and simplifies day-to-day work tasks. On the Home tab in the Number group click the percentage symbol to apply a Percentage format.