+ Reply to Thread
Results 1 to 2 of 2

How to increase an entire collumn by a certain percentage?

  1. #1
    Josh
    Guest

    How to increase an entire collumn by a certain percentage?

    I have a collumn of dollar amounts that I want to increase by a certain
    mulaplier, say 35%. Is there any way to do this? The collumns are on
    average 30 rows long, with various amounts.

  2. #2
    Connie Martin
    Guest

    RE: How to increase an entire collumn by a certain percentage?

    In an empty cell somewhere type 1.35 (for 35%). Then do the following:
    1. Select and copy that cell with 1.35 in it
    2. Then select the column of numbers that you want increased by 35%
    3. Click Edit/Paste Special
    4. Under Paste, select "Formulas"
    5. Under Operation, select "Multiply"
    6. Click OK

    "Josh" wrote:

    > I have a collumn of dollar amounts that I want to increase by a certain
    > mulaplier, say 35%. Is there any way to do this? The collumns are on
    > average 30 rows long, with various amounts.


+ 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