How can I change the entire column by the same percentage?

**Mdlee** · 05-13-2009, 06:20 PM

I have a column (G2:G128). Each one of the fields in this column have a number. I want to reduce each one of the numbers in the fields by 25%.
What is the formula that I need to use to make this happen?

**martix** · 05-13-2009, 06:28 PM

An array formula is easiest. Percentages are also numbers so select where you want the result(say H2:H128) and type "=G2:G128*0.75" and use Ctrl+Shift+Enter to enter the formula.

**Mdlee** · 05-13-2009, 06:44 PM

That doesn't quite give me the results that I'm looking for. I tried doing what you recommended however that solution gives the results in a new column. I have to keep the data in the same column. Any way to do that?

**martix** · 05-13-2009, 07:42 PM

Oh... I see. Well assuming that the column in question does not contain any formulas - do as said and then just copy the new column to the old one and choose to paste only the values and then delete it.
If however it does contain formulas then its even easier - multiply the whole formula by your percentage (0.75 in your case).

**shg** · 05-13-2009, 08:15 PM

Enter 0.75 in a cell. Copy that cell.

Then select all the cells of interest, and do Edit > Paste Special, and tick Multiply and Values

**martix** · 05-13-2009, 08:38 PM

Heh... I never knew that trick. Thanks here too. :P

**zbor** · 05-14-2009, 01:41 AM

If you need change that value from time to time best way is to put it in some cell (e.g. D1) and in new column (e.g. H) do calculation

$D$1*G2 and extend to H128