How Do I Calculate a Percentage In a Excel Worksheet Using a Formula?


3 Answers

Jack Buckby Profile
Jack Buckby answered
The easiest way to lay this out and calculate is to break the sums down in to a number of cells.

First put your initial figure in to a cell - here I will use the first one available but you can change it based on the arrangement of your spreadsheet. So 3000 goes in to cell A1.

In the next cell, in this instance cell A2, put your second figure of 7.50. In the third cell, A3, don't input the answer. Instead insert a formula. This will mean you can adjust the first two factors and the calculation will be done for you.

To insert the first formula, click on the cell A3 and type =A1*A2. This means calculate the figure in cell A1 multiplied by the figure in cell A2. The answer will automatically appear in the cell A3.

Next we can calculate what 1 per cent of the figure in A3 is. In your next cell, A4, type =A3/100. This tells the spreadsheet to divide the figure in the cell A3 by 100.

The next step is to show what 8 per cent of the figure is. This is easy. Create a new cell, I'll use A5. Type the formula =A4*8. The computer will multiply the figure in A4 by 8 and put the answer in the A5 cell. So A5 will show you what 8 per cent of your initial figure of 22,500 is.

Finally we can produce a total in the final cell, A6. To do so we need to show the result of the first calculation with the figure of 8per cent added to it. Therefore in the cell type =A3+A5.

So from your question and following it through as above, the spreadsheet cells will read as follows:
A1 - 3000
A2 - 7.5
A3 - 22,500
A4 - 225
A5 - 1687.5
A6 - 24187.5

There are faster ways to show this on the spreadsheet using more detailed formulas in fewer cells. This is the easiest way though as it shows a series of simple calculations. The benefit of doing it this way is that if you change the value in the cell A1 or A2, all of the other values will change and you can visible break down what it means.
Summbal Raheem Profile
Summbal Raheem answered
In excel its very easy to calculate this kind of caculations. Suppose from your example if your amount 3000 is in cell(b6) and multiplicant 7.5 is in c6 then you can place this formula in next cell as "=(B6*C6)+(((B6*C6)*8/100) )". It will will work. And you answer will be=24300 
Karl Sagan Profile
Karl Sagan answered

I try to keep a record of my money at all times so I know how much I can spend, how much I need to save and stuff like that. I also use an excel spreadsheet for this thing. I saved a lot of money this month, by the way. I've been planning to buy a new tablet for a long time, but now I can't afford a new device from the store. I found refurbished tablets UK supplier, which sells refurbished tablets that are significantly lower in price, but they don't compromise on quality at all.

Answer Question