Excel help please

[tbone]

Hi I hope I am posting in the right place,,,I am having a problem tryng to
calculate nimbers on Excel...what I want to do is say in column A i have over
200 different figures going down the page ..what i want to do is add 20% to
each figure without having to manually do it..is there a formula that will
allow me ot do this...It is doing my brain and I cant get my head round it..I
would appreciate any help.

 

[Carey Frisch [MVP]]

Please repost your question in the Microsoft Excel Discussion Group:
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

--
Carey Frisch
Microsoft MVP
Windows Shell/User

---------------------------------------------------------------

:

Hi I hope I am posting in the right place,,,I am having a problem tryng to
calculate nimbers on Excel...what I want to do is say in column A i have over
200 different figures going down the page ..what i want to do is add 20% to
each figure without having to manually do it..is there a formula that will
allow me ot do this...It is doing my brain and I cant get my head round it..I
would appreciate any help.

 

[Rick Rogers]

Hi,

Questions like this belong in a group designed for Excel. I believe the
formula you want for column B is =sum(A1,(A1*0.2)), then drag it down for
the column.

--
Best of Luck,

Rick Rogers, aka "Nutcase" - Microsoft MVP

Windows help - www.rickrogers.org
My thoughts http://rick-mvp.blogspot.com

 

[tbone]

thanks for that ...I have done so...not too sure how to use these forums
properly so that would explain it..lol