There are two quick ways to calculate percentages in Google Sheets. Both methods are by writing formulas. So, in this tutorial, we will learn both ways in detail.
Calculate Percentage with Divide and Format Method
Please use the below steps:
- In a cell, enter the (=) equals sign and then refer to the cell where you have the number for which you want to calculate the percentage.
- After that, enter a forward slash, the divide operator for calculation. You can use the button on the keyboard to enter it.
- Now, refer to the cell where you have the number you want to calculate the percentage.
- Next, hit the enter button to get the result for the formula you entered in the cell. (Make sure to have no space within the formula).
- Finally, click the “Format as Percentage” button from the menu bar to apply the percentage format to the cell.
=B1/A1
=value/total_valueAs you can see in the above example, the moment you click the “Format as Percentage” button, it applies the percentage format to the selected cell. You can also use the percentage with the shortcut key (Ctrl + Shift + %).
Divide and then Multiple with 100 to Get the Percentage
It is another method which you can use to get the percentage. In this method, you must divide and multiply the numbers by 100 to get the result.
=(B1/A1)*100
- Enter = in a cell, a starting parentheses ( and then refer to the cell with the number you want to get the percentage.
- After that, enter forward slash (/) to use as the divide operator.
- Next, refer to the cell with the number you want to calculate the percentage. Then, enter the closing parentheses.
- Now, enter an asterisk used as a multiply operator and then enter 100 to multiply.
- In the end, hit enter to get the result.
And if you want to add the percentage sign with the result, you can use the below formula.
=((B1/A1)*100)&”%”