| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reduce filesize | Excel Discussion (Misc queries) | |||
| Reduce code | Excel Discussion (Misc queries) | |||
| Reduce subtotals all at once? | Excel Discussion (Misc queries) | |||
| How to reduce table? | New Users to Excel | |||
| Reduce # of pages | Excel Discussion (Misc queries) | |||
Linear Mode
