Help for an Old Guy....PLZ!!!

[ThisOne]

New here and not well versed in Excel.....(this is an understatement). And my problem is this......... I have one price I input (say column D), I am plodding thru trying to come up with a formula that would give me the following: A 44% increase in column C A 30% decrease (from D) in column E A 15% decrease (from E) in column F A 20% decrease (from E) in column G Now I have thousands of these to do, hence the search for a formula. I hope that someone may have this figured out. Thank you for your time and efforts.

 

[VoG]

Try like this

Excel Workbook
	C	D	E	F	G
1	14.4	10	7	5.95	5.6
Sheet3

 

[ThisOne]

Mr. VoG..............Thank you!!!
How would I be able to apply this to approx 5000 rows?

 

[VoG]

For example: once you have entered the formula in C1, click in C1 then hover the cursor over the bottom right corner of the cell. The cursor should turn into a +. When it does, hold down the left mouse button and drag down as far as needed.

 

[ThisOne]

Mr. VoG..............Thank you!!!
How would I be able to apply this to approx 5000 rows?

Is it "COPY"....then "SPECIAL PASTE"..??

 

[ThisOne]

Mr.VoG, Thank You for your time, I hope that You have a great day there in Ruislip (?)