The percentage function in Google Sheets What is that? How to calculate the percentage in Google Sheets how? Let's find out with Quantrimang.com!
To calculate the percentage in Google Sheets we have many different ways, follow the normal percentage calculation or use the percentage function in Google Sheets. Below is a detailed instruction in the Google Sheets.
1. Calculate the percentage of Google Sheets by division calculation
Users will perform a division calculation by the total to get a percentage value, then format that number as a percentage with the formula. = Number/total.
Apply immediately to the formula below, we will take 25/100 to get value.
You can enter the formula is = E90/F90 or = E90/100 or enter 25/100 and also get the same result.
Automatically format percentage
To automatically format the data for data, we use the function = To_percent (value). You apply the function formula to the calculation as shown below.
The value results are automatically formatted as percentage as shown in the picture.
Or you can apply the formula in different functions but still produce percentage results.
Mandarial format percentage in Google Sheets
In case you use division and then want to format the percentage value, you can use the digital format tool in Google Sheets.
Click on division results In the table and then click icon 123 and then select the percentage To format the value in the form of a percentage.
Value results will be converted into a percentage as below. If necessary, you can also adjust the decimal to get the percentage value as you like with the two icons in the picture below.
2. Calculate the percentage of Google Sheets by multiplication
In addition to the percentage division as above, we can perform multiplication to calculate the percentage value with the formula = (number/sum)*100.
Applicable to the above formula we will have calculation = (E90/F90)*100.
Press Enter and then display the value of this calculation. In addition, you can also perform other calculations and also produce similar results: = (E90 / 75) * 100 or = (25/75) * 100.
3. Instructions for calculating the percentage in the sheets with the percentif function
With more complex percentage calculations on Google Sheets, the use of love as these two ways is not feasible. Then we will have to use more Percentif function in Google Sheets.
The percentif function formula in Google Sheets = percentif (Range, Criteria), in which Criteria may be a number, text or reference. Percentif function in Google Sheets automatically format percentage for value.
For example, finding a percentage of school supplies begins with characters B in the column list B.
We will enter the function formula = Percentif (b31: b36; “b*”)) Then click Enter to do.
The result will display the percentage of tools starting with the letter B in the list.
How to use customized number format for percentage
In this way, the formula will not multiply with 100. Instead, it will be the number format.
Moreover, with this method, you can round the decimal and add a percentage in the same step.
Consider the following example:
- Select the box you want to change the percentage.
- In the formula bar, enter: = (C2-B2)/B2
- Press Enter.
- Pull the Dien and drop it into the cells below.
The formula we use here does not multiply with 100. You will see the result will now change the ratio, not a percentage. You can fix this problem in custom format:
- Choose cells containing ratio changes.
- From this menu, to format, then select Number.
- Select custom number format.
- In the text box, enter 0, one decimal sign, then many other zero to verify the decimal number.
- Add percentage mark to custom format.
- Click Apply.
And here is the final result:
