How to Reduce value in a column by 5%?

C

capxc

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?
 
B

Bernard Liengme

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
 
B

Bob Phillips

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

Select D1:D2400, and goto to Edit>PasteSpecial, and click the Multiply
option.

OK out and clear that spare cell.
 
G

Gary''s Student

In an unused cell enter .95 Copy that cell and paste/special/multiply onto
the values you are trying to change.
 
M

Mike H

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
 
J

James Silverton

Bob wrote on Mon, 14 Jul 2008 15:21:13 +0100:
Not if its in E1
Click to expand...

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
 
B

Bob Phillips

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.
 
Top