How to calculate percentages in Excel

If you’re using Microsoft Excel to handle numerical information, in some unspecified time in the future you are inevitably going to show percentages.

Doing so can provide you a brand new perception, or make summarizing heaps of knowledge a bit simpler. That is the place the share system in Excel can provide the reply you want in seconds. And don’t fret, calculating percentages in Excel would not require difficult steps.

Right here’s how you can calculate percentages in Excel.

What’s the system to calculate share?

There are numerous formulation you need to use to calculate a share. Listed below are two of the commonest strategies.

Step 1: On this particular instance, I’ll be calculating the distinction between the revenue and income. Choose the cell you need the share to seem inside. Now sort in =(B2-C2)/B2. The / represents the division perform.

Step 2: Press the Enter key in your keyboard as a way to affirm the system.

Step 3: Within the toolbar, choose the Share icon. In my instance, there’s a 65% distinction between the revenue and income. If I modify the revenue quantity to the next determine, that share will decline.

Step 4: One other system you need to use to calculate share is solely making use of the / key in between two cells. For instance, to cross a driving concept check, I have to get 80% of the questions appropriate. To seek out out the share for this particular query, I’ve entered =B2/C2.

What’s the best solution to discover percentages?

Now that we’ve defined how you can calculate percentages, let’s check out the best solution to discover percentages by way of the drag function.

Step 1: Choose the cell the place you’ve entered the system to calculate a share.

Step 2: On the bottom-right nook of that cell, drag it right down to the place your column ends, or wherever you need percentages to be proven.

In my instance, I’ve dragged it right down to reveal the distinction between the share of revenue being generated in comparison with the income for every month that’s listed inside my spreadsheet.

How do I discover 10% of a quantity in Excel?

Discovering a selected share of a quantity inside your spreadsheet could be achieved by way of a simple system.

Step 1: Choose the cell you wish to discover the share of a quantity in.

Step 2: Now enter, for instance, =10%50. The asterisk on this system represents the multiplication perform. Press *Enter in your keyboard to verify the end result.

Step 3: I’ve utilized this similar system on my fundamental Excel revenue versus income spreadsheet as nicely. Simply substitute the quantity 50 with the cell quantity the place the determine is positioned.

For extra on Excel’s different features, take a look at our guides on how to use concatenate, and how to use IF in Excel.