Cara Menghitung Persentase di Google Sheets – Panduan Rumus yang Mudah

This document outlines the steps to calculate the concentration percentage using a spreadsheet.

Calculating percentages in Google Sheets is pretty straightforward. You can either do the math manually or let Google Sheets handle the formatting for you.

1. Use the basic formula
The standard way to find a percentage is to divide the part by the total, then multiply by 100.
For example, if you want to know what percentage $30 is of $200, you’d type:
= (30 / 200) * 100
That gives you 15%.

2. Use cell references
Instead of typing numbers directly into the formula, you can use cell references.
Let’s say the portion is in cell B1 and the total is in B2. You’d write:
= (B1 / B2) * 100
This makes it easy to update values later without changing the formula.

3. Format as a percentage instead
To skip the * 100 part, you can just divide the values and format the result as a percentage.
For example:
= B1 / B2
Then go to the menu and click Format > Number > Percent. Google Sheets will automatically convert it to a percentage for you.

4. A real example
Say you're tracking sales and want to see how much one category contributes to the total. Just divide the category’s sales by the total sales. Then format the result as a percentage or multiply by 100 whichever you prefer.

Step-by-Step Guide: How To Calculate Percentage In Google Sheets

Step 1

Begin by selecting the column that contains the data for which you need to calculate the concentration.Add the total using: =SUM(range)

For example, if values are in D2**:E2**, calculate the total in F2: =SUM(D2/E2)

Identify and select the two values that need to be included in the calculation.

Step 2

Proceed to compute the sum and then navigate to the next step.

Step 3

Click on the values to view an example of the calculated answer below.

Step 4

• Format it as a percentage:

• Select the cell.

• Go to Format > Number > Percent or click the % icon in the toolbar.

Notice the calculated value showing as 11 percent.

Step 5

Observe the number associated with the percentage.