How to Calculate Percentage in Google Sheets

How to Calculate Percentage in Google Sheets 15

In this article we are going to learn how to calculate percentage in Google sheets. While percentage formula is quite common and easy to learn as we do calculate percentages in academic activities similarly, we have the same rules and formulas we will learn through as we had practiced more basic operations in the past.

A percentage is a number or ratio expressed as a fraction of 100 which gives a sense of proportion and find easy to understand and helps visually with expressions for comparison, etc. We need this operation in every field like banking, business, schools, offices, companies &, etc. so we must know how to calculate percentages in Google sheets because as we know Google sheets is an application more for calculations, analysis, and data indexing when working in Google Sheets. You’ll often find that you need to use percentages to calculate sales tax, test scores, inflation rates, and many other everyday concepts.

Fortunately, Google Sheets makes it easy to calculate and format percentages with simple formulas and a few clicks.

Why do we need to Calculate Percentage in Google Sheets

As we know usually, we have the bulk of data analysis in Google sheets and a large number of calculations sometimes it is very hard to understand and estimate any kind of loss, profit, or sale. Whereas, percentage makes visualization very easy to understand and make an estimate. We use percentage formulas in various situations like to fetch profit or loss of sales, quantities, and stock remaining and also in offices for staff salaries, bonuses, and deductions and in schools for student’s annual reports in companies to maintain a record of raw materials and many more.

So we may not ignore percentage operation from our calculation that’s why we need to learn how to calculate percentages in Google Sheets.

See also  How to Make Negative Numbers Red in Google Sheets [2 Methods]

How to Calculate Percentage in Google Sheets

First, let’s see the general formula or syntax of the Percentage.

Syntax

=(Value/total number)*100

There are three arguments in this syntax

Let’s see all of them step by step:

Step 1

First, have  some collection of sample data

How to Calculate Percentage in Google Sheets 1

Step 2

Now applying the formula first we will take the first argument of the syntax, which is the amount

How to Calculate Percentage in Google Sheets 2

Step 3

Now the second argument is the total amount

How to Calculate Percentage in Google Sheets 3

Step 4

Similarly, the third argument which is multiplying to 100 as constant

How to Calculate Percentage in Google Sheets 4

Yes, we are done now there is the result you can see below

How to Calculate Percentage in Google Sheets 5

You may also verify the answer by summing up all the values you will find a 100% result at the end

How to Calculate Percentage in Google Sheets 6

As you are looking that percentage numbers are showing in decimal extra points and looking confusing for beginners. It will be fixed by changing the format, or decreasing the decimal points by button as shown in the figure below:

How to Calculate Percentage in Google Sheets 7

See also  How to Convert Text to Numbers in Google Sheets

Percentage in Google Sheets – Application of Percentages

There are various ways of percentages but in this article, we are going to discuss these three types of percentages that will help you with almost all scenarios to find percentages so let’s start step by step.

  • Proportion of Percentage
  • Total Percentage
  • Percentage Change

How to Calculate Percentage in Google Sheets – Proportion Percentage

The proportion of percentages is the numbers expressed in a fraction of 100. Let’s suppose we have a target of some goods to sell and we achieve different numbers of them so it is hard to remember of individual quantity but we can make an estimate easy to understand and to remember same as in any Shop or Factory we have an entire stock of different goods and color so we can’t major their sales rate and which product is attracting buyers most so we can judge them by this calculation easily as shown data below,

Step 1

Collect the data below

How to Calculate Percentage in Google Sheets 8

Step 2

The formula for this method is simply as

Sale made/target sale*100

There are three arguments as we discussed the syntax previously

For the first argument

How to Calculate Percentage in Google Sheets 9

Step 3

Now pass the second argument as:

How to Calculate Percentage in Google Sheets 10

Step 4

Now the third argument is to multiply by 100 to get the result 

How to Calculate Percentage in Google Sheets 11

We may also use the percentage button instead of multiplying by 100 as shown in the picture.

How to Calculate Percentage in Google Sheets 12

Here is the result in front of you, as you may see the percentage of sales made and how many percent, which product is giving good sale.

See also  How to Automatically Sort Dataset in Google Sheets

How to Calculate Percentage in Google Sheets – Total Percentage

We have some collection and we have to find the total percentage of them is term as a total percentage, which we commonly used in our daily routine it helps and makes efficient our daily tasks as we have a stock market and we don’t know about the number of goods remaining in stock but we know total numbers of items in our stock, for example, we have some this kind of data

How to Calculate Percentage in Google Sheets 13

The syntax to calculate the total percentage is,

Formula =(Value/total number)*100

To find the total percentage first we will have to find the sum of the total value

How to Calculate Percentage in Google Sheets 14

As shown in the figure we know the number of items and the total number of verity but it is hard to understand which item is going to an end and which have much stock we can estimate it by using this term, applying the above formula

How to Calculate Percentage in Google Sheets 15

Now we can easily estimate which color of shirts came to end and which are not the same as we may also estimate which color of T-Shirts are being sold most and which one is not and which color of T-Shirt stock remains and which one is not. This method of percentage also helps to find the ratio of products sales rates also helps to indicate which product is giving profit or loss. Similarly, we can use this method percentage in many cases of our daily routine calculations and analysis.

See also  How to Make a Scatter Plot in Google Sheets (Complete Guide)

How to Calculate Percentage in Google Sheets – Percentage Change

Let’s suppose we are monitoring staff working in a mall or shop it is very hard to monitor and make understood that which employee is giving good performance and making effort to increase our sales but by this method we may make it easy by making this situation data that make a table of staff and separate them with individual month’s sales.

Like

How to Calculate Percentage in Google Sheets 16

Then apply the formula of percentage change then you may easily know the different rate of sales for every employee it is quite easy,

Syntax of Percentage change is,

Formula = (Sales Month 2 – Sales Month 1)/ Sales Month 1*100

There are also three arguments and there are 3 different operations as well which we will perform step by step

Step 1

First, we will subtract 2nd month’s sales from the first month as described in the formula

How to Calculate Percentage in Google Sheets 17

Note: Must use a bracket because we have to perform one more operation further.

Step 2

Now we will divide the obtained value by 1st month’s sales value like

How to Calculate Percentage in Google Sheets 18

Step 3

Now just multiply it by 100 or press the % button

How to Calculate Percentage in Google Sheets 19

Here is the percentage you have got by this you may easily an estimate that we have got how much change in our sales rate between the current or previous month of every employee. By this, we may know about any kind of progress even for any employee as well and also for our product’s sales rate that which product was sold in what quantity previous month and this month.

Simple is that we may find many benefits of percentage change which helps and make our official and business tasks easy and comfortable.

See also  How to Stop Rounding Numbers in Google Sheets (2 Methods)

Tips and Precautions – How to calculate percentage in Google sheets

As we know that Google sheets are the place for providing online spreadsheets where we can do our calculations, analysis, billing, tables, etc. We also know in calculation or mathematics operations we need to care too much for every sign or symbol same as we have to be concerned about every formula or condition while applying it in Google sheets.

As you notice somewhere while applying formula or Cell reference I used somewhere ‘$’ sign to absolute cell reference like

How to Calculate Percentage in Google Sheets 20

As you can see in the above screenshot, I used the $ sign while referring to the cell reference of B12 as an absolute reference, it is so that it is being divided by every cell value B5 and so on. The $ sign is used to specify that a reference is absolute, so it does not change when you copy the formula to the other cells or even drag down the formula to the below cells, otherwise, you may get some problems or errors while applying the formula and will not get the correct answer because the values will be changed by the change of the cell references

Frequently Asked Questions

How calculating Percentage can be useful for us?

Percentages are useful for lots of things in everyday life, including comparing two or more groups, estimating a population percentage from a sample percentage, tracking the performance of an individual, calculating and analyzing sales profit discounts at a store, Sports (statistics about batting average, etc.), Tax rates (income, sales, property) and in so many cases the term percentage is very helpful and makes calculation very easy to understand and make remember. This is why we need to learn this term as we did and also we practiced all applications of percentages which will help you with any criteria.

See also  How to Rotate Text in Google Sheets [Complete Guide]

Conclusion

In this article, we learned How to calculate percentages in Google sheets. We also learned some conditions when we need to calculate percentages we learned Proportion of percentage we learned Total Percentage and Percentage Change; I know your scenario for calculating percentages can be different as well but these three conditions will help you almost in all criteria what you have to may find your percentage for all possibilities.

As we find that percentage makes easier and understood calculations and analysis of any things Products sales rates, stock management, staff reports as we studied. We may also use these conditions in student report cards, Billing management, Salary slips, Business calculations and forecast, and other financial issues.

I hope you find this article helpful. Thank you and Keep learning with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general