How to Reduce value in a column by 5%?
 

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

1) In E1 type =D1*(1-5%); copy this down the column by double clicking the
fill handle of D1
or
2) In E1 type 0.95; copy E1; select D1:D24000; use Edit | Paste Special and
specify Multiply, click OK; now delete E1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"capxc" wrote in message
...
Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not
work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

Put the value 0.95 in a spare cell and copy that cell.

Select D1:D2400, and goto to EditPasteSpecial, and click the Multiply
option.

OK out and clear that spare cell.

--
__________________________________
HTH

Bob

"capxc" wrote in message
...
Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not
work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

Have you tried the following formula:

=D1-(D1*0.05)
--
Kevin Backmann


"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

In an unused cell enter .95 Copy that cell and paste/special/multiply onto
the values you are trying to change.
--
Gary''s Student - gsnu200794


"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

Hi,

I'm not sure where the buttons are in 2007 but the prnciple will be the
same. Put 0.95 in a cell somewhere and copy it.

Select your range then use paste special multiply.

Mike

"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

Kevin wrote on Mon, 14 Jul 2008 06:33:01 -0700:

Have you tried the following formula:

=D1-(D1*0.05)
--
Kevin Backmann

"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that
column by 5%. I have 07 Microsoft Office and I tried couple
formulas but it did not work. Can anyone tell me how to do it
the right way? -- capxc

Circular reference isn't it?
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

How to Reduce value in a column by 5%?
 

Not if its in E1

--
__________________________________
HTH

Bob

"James Silverton" wrote in message
...
Kevin wrote on Mon, 14 Jul 2008 06:33:01 -0700:

Have you tried the following formula:

=D1-(D1*0.05)
--
Kevin Backmann

"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that
column by 5%. I have 07 Microsoft Office and I tried couple
formulas but it did not work. Can anyone tell me how to do it
the right way? -- capxc

Circular reference isn't it?
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

How to Reduce value in a column by 5%?
 

Bob wrote on Mon, 14 Jul 2008 15:21:13 +0100:

Not if its in E1

--
__________________________________
HTH

Bob

"James Silverton" wrote in
message ...
Kevin wrote on Mon, 14 Jul 2008 06:33:01 -0700:

Have you tried the following formula:

=D1-(D1*0.05)
--
Kevin Backmann

"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that
column by 5%. I have 07 Microsoft Office and I tried couple
formulas but it did not work. Can anyone tell me how to do it the
right way? -- capxc

Circular reference isn't it?

This circular argument could go on for ever :-) The question was how to
"reduce all values already entered"
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

How to Reduce value in a column by 5%?
 

I agree that he isn't answering the question as it was specifically asked,
but he also did not say enter it in D1, so there was an assumption on your
part to suggest that was circular. And you have to admit, whilst it may not
suit the OPs (presumed) needs, it is a darn sight more flexible than the
other solution offered.

--
__________________________________
HTH

Bob

"James Silverton" wrote in message
...
Bob wrote on Mon, 14 Jul 2008 15:21:13 +0100:

Not if its in E1

--
__________________________________
HTH

Bob

"James Silverton" wrote in
message ...
Kevin wrote on Mon, 14 Jul 2008 06:33:01 -0700:

Have you tried the following formula:

=D1-(D1*0.05)
--
Kevin Backmann

"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that
column by 5%. I have 07 Microsoft Office and I tried couple
formulas but it did not work. Can anyone tell me how to do it the
right way? -- capxc

Circular reference isn't it?

This circular argument could go on for ever :-) The question was how to
"reduce all values already entered"
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

How to Reduce value in a column by 5%?
 

Formula in option2 solved the problem. Thanks.
--
capxc


"Bernard Liengme" wrote:

1) In E1 type =D1*(1-5%); copy this down the column by double clicking the
fill handle of D1
or
2) In E1 type 0.95; copy E1; select D1:D24000; use Edit | Paste Special and
specify Multiply, click OK; now delete E1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"capxc" wrote in message
...
Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not
work.
Can anyone tell me how to do it the right way?
--
capxc

How to Reduce value in a column by 5%?
 

Thanks everybody. I learned a lot from all the contributions.
Sincerely,
--
capxc


"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc