Excel help please

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.

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

--
Carey Frisch
Microsoft MVP
Windows Shell/User

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

"tbone" wrote:

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.

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
http://mvp.support.microsoft.com/
Windows help - www.rickrogers.org
My thoughts http://rick-mvp.blogspot.com

"tbone" <> wrote in message
news:5685C271-AECC-4E5B-B998-...
> 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.
>

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

"Carey Frisch [MVP]" wrote:

> Please repost your question in the Microsoft Excel Discussion Group:
> http://www.microsoft.com/office/comm...&lang=en&cr=US
>
> --
> Carey Frisch
> Microsoft MVP
> Windows Shell/User
>
> ---------------------------------------------------------------
>
> "tbone" wrote:
>
> 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.
>