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. How to Calculate a Percentage of a Number. Heres the formula in cell C3.
Since only three of the four cells in the range contain data the formula calculates the percentage of yes responses out of three.
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 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. Select the cell where you want to display the percentage. Type the following formula into any Excel cell.