+ Reply to Thread
Results 1 to 6 of 6

Percentage increase for column

  1. 04-07-2008, 07:12 PM #1
    Help! is offline
    Registered User
    Join Date
    04-07-2008
    Posts
    4

    Percentage increase for column

    I want to increase all numbers in cells A1 to Axxx by 10%. I also want to create a new column (B) to show this new set of numbers (increased by 10%).
    Thanks
    Reply With QuoteRegister To Reply
  2. 04-07-2008, 07:17 PM #2
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    In B1 and copy down =A1 * 110%
    Reply With QuoteRegister To Reply
  3. 04-07-2008, 07:43 PM #3
    Help! is offline
    Registered User
    Join Date
    04-07-2008
    Posts
    4
    shg - how do I "copy down"?
    Reply With QuoteRegister To Reply
  4. 04-07-2008, 07:59 PM #4
    Help! is offline
    Registered User
    Join Date
    04-07-2008
    Posts
    4

    Percentage increase for column

    I understand the formula and the proper cell, but how do I "copy it down" to include all rows in this new column?
    Thanks
    Reply With QuoteRegister To Reply
  5. 04-07-2008, 08:26 PM #5
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Select the cell and drag the fill handle (the little square at the bottom of the selection box) down.
    Reply With QuoteRegister To Reply
  6. 04-07-2008, 08:58 PM #6
    Help! is offline
    Registered User
    Join Date
    04-07-2008
    Posts
    4
    shg,
    I still don't understand.
    also, What if I have 50,000 rows to calculate?

    Thanks..this is new to me
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1