+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Registered User
    Join Date
    05-15-2006
    Posts
    3

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

    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?

  2. #2
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2016
    Posts
    82

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

    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.

  3. #3
    Registered User
    Join Date
    05-15-2006
    Posts
    3

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

    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?

  4. #4
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2016
    Posts
    82

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

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

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

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

    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
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2016
    Posts
    82

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

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

  7. #7
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1