How To Calculate Percentages?

[Bazza06]

Hi,

What formula do I need to enter in order to create an automated calculation of percentage?

For example, if I have the figure 100 in cell 1A and I want to add 8% and have that appear in 2A, and then by dragging the cells down have each subsequent cell add a further 8% to the previous total, how do I achieve that?

Thanks for your help.

 

[johnnyL]

You looking for a formula or vba code or don't care?

 

[johnnyL]

Formula for A2 could be
= A1 * 1.08

You could then drag that down the column if desired.

 

[Michael M]

Try using

Book1
	A	B	C	D
1	100	108		108
2	85	91.8		116.64
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=A1*1.08
D1	D1	=A1*1.08
D2	D2	=D1*1.08

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I suspect that your question may have already been answered but another interpretation is that you want to keep adding 8% of the original value as opposed to 8% of the last calculated value.

22 06 19.xlsm
	A
1	100
2	108
3	116
4	124
5	132
6	140
Add %

Cell Formulas
Range	Formula
A2:A6	A2	=A1+0.08*A$1

 

[Bazza06]

Thanks to everyone that replied.
I tried the first suggestion from @johnnyL which worked perfectly for what I required.
I'm sure all other suggestions would work equally well, so thank you.
@johnnyL I'm not an experienced user of Excel, so unsure of the difference between formula and VBA.
@Peter_SSs - thanks for the suggestion to update my account details. I'll go ahead and do that.

 

[Peter_SSs]

thanks for the suggestion to update my account details. I'll go ahead and do that.

Thanks for updating.

You may well decide to stick with the marked suggestion, but since you have MS365, if you knew how far down you wanted the results to go, you could do it with a single formula that does not need to be dragged down at all. For example, in the mini-sheet below, the post 3 formula has been entered and dragged down to fill 9 rows. The formula in B2 does not need to be dragged down at all, the results automatically 'spill' down. As you can see, the results are the same.

22 06 19.xlsm
	A	B
1	100	100
2	108	108
3	116.64	116.64
4	125.9712	125.9712
5	136.048896	136.048896
6	146.9328077	146.9328077
7	158.6874323	158.6874323
8	171.3824269	171.3824269
9	185.093021	185.093021
10	199.9004627	199.9004627
Add %

Cell Formulas
Range	Formula
B2:B10	B2	=B1*1.08^SEQUENCE(9)
A2:A10	A2	=A1*1.08
Dynamic array formulas.

 

[Bazza06]

Thank you, Peter.
That's really helpful to have an alternative solution as I may be looking at scenarios over a defined period