PERCENTAGE FORMULA GOOGLE SHEETS HOW TO

Notice that in the formula in the example, a dollar sign was added before the row reference for cell E1, like this: E$1 The formula in cell C2 was copied and pasted into cell C3, which calculates the percentage of people who voted no, which is 25% (25/100 or B3/E1) Cell C2 is dividing 75 by 100 (B2/E1), which yields an answer of 75%. Cell E1 is calculating the total number of people who voted, which is 100. Then we will calculate the percentage of people who voted “Yes' (B2/E1), and we will also calculate the percentage of people who voted 'No' (B3/E1).Īs you can see in the image above, 75 people voted 'Yes', and 25 people voted 'No'. We will calculate the total number of people who voted for either option by using the SUM function in cell E1. What we have is data that shows how many people voted 'Yes' (cell B2), and how many people voted 'No' (cell B3). In this example, we will use the SUM function to calculate the total by putting the SUM function in its own cell, and then refer to that cell in the division formula that calculates percentage. Now let's go over an example where the 'Total' is not simply given in the data, and where we need to calculate the total in order to calculate the percentage. Calculating percentage of a total (using the SUM function)

If you want to remove the decimal places, click the “Decrease decimal places' button on the top toolbar two times, and the percentage will display without decimal places like in the image below (25%). By default when you select the percentage format, Google sheets will display two decimal places. To do this, select cell C2, then click the 'Format as percent” button on the top toolbar, which has a percentage symbol on it (%).Īs you can see in the image above, after formatting the cell as 'Percent', cell C2 now displays 25.00%. The number 0.25 is equivalent to 25%, but now we want to make the cell actually display in percentage format. To do this we divide the part by the total, which in this case is 25/100, or B2/A2 considering the cell references.Īfter dividing cell B2 (25) by cell A2 (100), cell C2 now displays the number 0.25. So the question is what percentage is 25 out of 100. What we want to do is find the percentage that the number in cell B2 represents (the part of the whole / total), when compared to the total in cell A2.Ĭell B2 contains the 'Part' (25), and cell A2 contains the total (100). Let's go over a basic example of calculating percentage. Calculate percentage of a number (basic example)

PERCENTAGE FORMULA GOOGLE SHEETS HOW TO

This article focuses on calculating the percentage of a total / number… but if you want you can click here to learn how to calculate the percentage increase from one number to another.

Click the 'Format as percent' button on the top toolbar (%)Īfter following these steps, the formula will display the percentage that the part / portion represents when compared to the total.The final formula will look like this, where the part: =25/100 (Or like this: =B2/A2) Type the number or the cell that contains the number that represents the total.Type the number or the cell that contains the number that represents the part of the total.To calculate the percentage of a number in Google Sheets, follow these steps:

Percentage formula google sheets