Percentage changes

[jknjp]

I have a table of numbers that I want to apply a percentage increase.
this persentage rate could change monthly

e.g.
colum B has list of numbers cell A1 has percent rate e.g. 8%

 

[VoG]

Enter 1.08 in A1 and copy it.

Select the numbers in column B, Edit > Paste Special, tick Multiply and click OK.

 

[jknjp]

Thanks, I will keep that in mind....

I wondered if there is a way to update all the figuers to show the percentage increase automatically
e.g B2 contains 200, if the percentage rate in a1 was 8% b2 would show 216 if the rate changed b2 would change.

regards

 

[VoG]

You would need to do that calculation in another column like this

Excel Workbook
	A	B	C
1	8%
2		200	216
Sheet1

 

[jknjp]

Perfect many thanks