Google Sheets: Calculating Percentage
Last Updated: January 17, 2022
Seeing rates in a spreadsheet is sometimes inevitable, primarily if your data comprises numbers purely. There are times when you’ll be required to compute the percentage to show the difference in proportions. Although this could be pretty tricky, you’ll be able to achieve this by simply following the steps below.
1. Open Google Sheets using your web browser.
Go to the Google Sheets website using your most commonly used web browser. Make sure to log into your account to access your previously created spreadsheets.
2. Select the spreadsheet that you want to edit.
From your previously created spreadsheets, select the one you wish to edit. Click on your selected spreadsheet to open it.
3. Enter the percentage formula into your preferred cell.
You can calculate the percentage of your data by dividing the portion by its whole. You can do this by using the “/” symbol, representing division. For this example, the proportion of the students who passed from those who took the exam will be calculated. The formula will be: Students who passed/Students who took the exam; whereas, in this case, B2/C2.
4. Press “Enter” on your keyboard.
To apply the formula you’ve entered, press the “Enter” key on your keyboard. You should see the answer in decimal after doing this.
5. Drag the formula down to apply it to the other cells.
Suppose you have multiple sets of data similar to this example. Instead of entering the formula over and over again, you could drag down the square symbol at the bottom-right corner of your formula cell. This will automatically calculate the subsequent rows, given that as you move the row of the formula cell, the data involved in the formula will follow depending on the row you’re in.
For example, if you drag down the formula to the next row, the formula will change into B3/C3, and so on.
6. Click on the percentage icon from the toolbar.
To apply the percentage format to your data, click on the percentage icon (%) on the toolbar above your spreadsheet. If you want to format a whole row or column, you can simply click on the row or column that you want to format before clicking the percentage icon. This will immediately format the cell or cells you’ve selected.
7. Adjust the number of the decimals of your percentage.
Notice that the default number of decimals that you’ll see in your rates is two. You may adjust the number of decimals depending on your preference, just click the icons next to the percentage icon. You could either increase or decrease the decimals. Note that doing this would automatically format your data.
Calculating percentages in Google Sheets can be quite tricky, as it involves inserting formulas and clicking on a few icons. Nonetheless, you’ll be able to accomplish it once you learn the steps mentioned above by heart. Just keep following it, and you’ll soon find it easy to do.