Percentage share is a popular term in business organizations. In other sectors, this term is also used. We will calculate the percentage share in Excel based on the formulas in this article.
Percentage share is the amount of share percentage obtained by each shareholder of a company or organization. Percentage share is important to divide the profit of the organization, as well as the losses.
The formula for percentage share is given below.
In this article, we will show 3 methods to calculate percentage share in different conditions in Excel.
In this section, we will show the calculation of the percentage share of two numbers of the total in Excel.
We have a dataset of the number of boys and girls in a class. We need to calculate the percentage share of boys and girls in the total.
📌 Steps:
- First, apply the following formula based on the SUM function on Cell D5.
=SUM(B5:C5)Â
- Press the Enter button.
- Now, add new rows for calculating the value percentage share.
- Before applying any formula, we change the number format of Range D7:D8. Select the range and press Ctrl +1.
- Choose the Percentage option from the Number tab.
- Now, input the number of decimal places in the marked box.
- Finally, press OK.
- Now, put this formula on Cell D7.
=B5/$D$5Â
- Press the Enter button.
We get the percentage share of boys.
- Put the below formula to get the percentage share of girls.
=C5/$D$5Â
- Again, press the Enter button.
We successfully get the percentage share of boys and girls of the total students.
In this section, we will show the calculation of the percentage share of one number with another.
We have taken a dataset that contains the value of X and Y. We will determine the percentage share comparing Y with X.
📌 Steps:
- Put the simple formula below on Cell C6 using division operation.
=C5/C4
- Finally, press the Enter button.
This is the percentage share after comparing Y with X.
Market share percentage means the market-capturing capability of a company. The formula for calculating the market share percentage is given below.
We have the dataset of the USA mobile phone market that contains the data of total units sold in the USA and the units sold by the iPhone. We will calculate the market share percentage of iPhones in Excel.
📌 Steps:
- Put the simple division formula on Cell C6.
=C5/C4Â
- Then, press the Enter button.
We get the market share percentage of the iPhone. We get the result in the percentage form as we format that cell as shown in method 1.
Read More: How to Calculate Market Share in Excel
Now, we will see the reverse, i.e. the % share is given, and you have to figure out an amount based on it.
In this article, we will show how to calculate the amount of percentage share from the total.
Here, we have taken a dataset. It contains the total profit and the percentage share of variable X. We need to calculate the amount of profit of X.
📌 Steps:
- Go to Cell C6 and insert the following formula.
=C4*C5Â
- Finally, press the Enter button.
We get the amount of profit against the percentage share of X.
Read More: How to Calculate Dividend Per Share in Excel
Here, our dataset contains the percentage share and the value of that percentage share. We will use that data to calculate the percentage share.
📌 Steps:
- Go to Cell C5 and put the following formula based on the division operation.
=C5/C4
- Press the Enter button now.
We just divide the value of the percentage share and get the total amount.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, we described 4 methods to calculate percentage share in Excel. We also showed the calculation of the market share percentage in Excel. I hope this will satisfy your needs and give your suggestions in the comment box.
