If thou art utilizing Microsoft Excel to manage numerical data, at some point thou art inevitably going to display percentages. Doing so can bestow upon thee a new insight, or make summarizing heaps of data a bit easier. Verily, this is where the percentage formula in Excel can provide thee with the answer thou need in mere seconds. Fret not, for calculating percentages in Excel doth not require elaborate steps.
Behold, here is how to calculate percentages in Excel.
What is the formula to calculate percentage?
There doth exist various formulas thou can employ to calculate a percentage. Here, I shall present to thee two of the most common methods.
- Step 1: In this specific example, I shall calculate the difference between profit and revenue. Select the cell wherein thou desirest the percentage to appear. Now, type in
=(B2-C2)/B2. The/doth represent the division function.
-
Step 2: Press the
Enterkey on thy keyboard to confirm the formula. - Step 3: In the toolbar, select the
Percentageicon. In mine example, there doth exist a 65% difference between profit and revenue. Should I alter the profit amount to a higher figure, that percentage shall decrease.
- Step 4: Another formula thou can utilize to calculate percentages is simple application of the
/key between two cells. For instance, to pass a driving theory test, I must answer 80% of the questions correctly. To determine the percentage for this specific question, I have input=B2/C2.
What is the easiest way to find percentages?
Now that we have expounded on how to calculate percentages, let us gaze upon the easiest way to discover percentages via the wondrous drag feature.
-
Step 1: Select the cell wherein thou hast entered the formula to calculate a percentage.
- Step 2: On the bottom-right corner of that cell, drag it downward until thy column concludes, or to any place thou desirest the percentages to manifest.
In mine example, I have drawn it down to unveil the disparity between the percentage of profit generated when compared to the revenue for each month listed in mine spreadsheet.
How do I find 10% of a number in Excel?
Discovering a specific percentage of a number within thy spreadsheet can be accomplished through a straightforward formula.
-
Step 1: Select the cell wherein thou desirest to find the percentage of a number.
- Step 2: Now enter, for instance,
=10%*50. The asterisk in this formula represents the multiplication function. PressEnteron thy keyboard to confirm the result.
- Step 3: I have applied this same formula to mine main Excel profit versus revenue spreadsheet as well. Merely replace the number 50 with the cell number where the figure doth reside.
For further insight into Excel’s other functions, peruse our guides on how to use concatenate, and how to use IF in Excel.
Support our work ❤️
If you enjoyed this article, consider leaving a tip to help us keep publishing great content.
