When working with data, being able to show your values as a percentage can be very helpful. Google Sheets provides an easy and straightforward way to convert values into percentages. In this post, we will explore the different methods of getting percentages in Google Sheets.
Method 1: Using the percentage format option
One of the simplest ways to convert a number to a percentage in Google Sheets is to use the percentage format option. Here’s how you do it:
- Select the cell(s) that you want to convert to a percentage.
- Click on the “Format” option in the menu bar.
- Hover over the “Number” option. A side menu will appear.
- Choose the “%” option from the side menu.
The number in your selected cell(s) will be converted to a percentage.
Method 2: Using a formula
Another way to get a percentage in Google Sheets is by using a formula. In particular, you can use the DIVIDE formula to do this. Here is a sample formula:
=DIVIDE(B2, B3)
In this formula, B2 is the partial value and B3 is the total value. The result of this formula will be a decimal. To convert it to a percentage, you can follow the steps in Method 1.
Method 3: Using the Percentage function
Google Sheets also gives you the option to use the PERCENTAGE function to calculate the percentage of a number. Here’s a sample formula:
=B2*100/B3
In this formula, B2 is the partial value and B3 is the total value. The result of this formula will be the percentage of B2 in relation to B3.
And there you have it! Three straightforward methods to get a percentage in Google Sheets. Whether you prefer to use the percentage format option or a formula, Google Sheets has got you covered.