|Connect us with


How to Calculate Percentage in Excel?

Percentage | Percentage of Total | Increase Decimal | Percentage Example

It is easy to find the Percentage in Excel. percentage means parts per hundred. that means per hundred what is the proportion? For example, 20% of the 100 is 20, it means '20 out of 100'. So percentages are always calculated on per hundred bases. and the symbol of the percentage is (%). in this tutorial you will get examples with explanations on how to find a percentage in Excel.

For Example, if any student obtained 350 marks out 600 total marks means, what is his percentage of marks?

The formula for percentage in Excel is Obtained Marks / Total Marks * 100.

That is 350 / 600 * 100=58.33% .

Percentage in Excel

In the below example, we need to calculate the percentage of total in Excel.

1. First, we need to divide B2/A2 using Division in Excel.

Percentage in Excel

2. you will get a decimal number (floating points).

3. To apply percentage format go to Home Tab, Number Group then click on percentage symbol.

CTRL + SHIFT + % is the shortcut key for Percentage in Excel.

Percentage symbol

4. After applying the percentage on Excel the cell value C2 shows with percentage.

Total Percentage

5. If you want to increase the decimal of the percentage, go to Home tab, Number Group, click on Increase Decimal Button.

Increase Decimal

6. In the same way, you can also decrease the percentage decimals by clicking Decrease Decimal Button.

Percentage Result

7. you can also get the same result without using % symbol. to get this do multiplication with 100.

Percentage Result Without Using Symbol

Percentage Example:

In the below example, the sales team has a Total Target and Achievements. now we need to calculate the percentage of achievement of each seller. to calculate the percentage on Excel, execute the following steps.

How to Find Percentage in Excel

1. First, divide achievement from targets.

2. drag the formula to the entire range.

Division to Find Percentage

3. Go to Home Tab, Number Group then click on percentage symbol to apply percentage format.

Result:

Percentage Result with Symbol

Invoice Tax Percentage Example:

Let's take one more example, we have one bill with Product Total and Invoice Total Before Tax, Sales Tax, and Invoice Total After Tax values. here we need to find what is the percentage of the Sales Tax? to achieve this just execute the below steps.

Invoice Percentage Example

1. First, Divide Sales Tax value by Invoice Total (Before Tax).

2. You will get divided value.

Invoice Percentage Example Setp-1

3. Apply the percentage symbol (%) to this value.

Result:

Invoice Percentage Example Result

Here, 18% is the Sales Tax applied to this bill.

These are simple ways to calculate percentages in Excel.

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.


To Get FREE Excel Shortcut Keys
       



Previous



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments




Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.