+ Reply to Thread
Results 1 to 2 of 2

How to add a fixed amount to all cells in a column

  1. #1
    Registered User
    Join Date
    06-30-2008
    Location
    cambridge
    Posts
    1

    How to add a fixed amount to all cells in a column

    Hi All,

    I am trying to figure out how to add a fixed amount in percent (ie. 10%) to all cells in a column.
    Here is an example:

    Price:
    1.00
    2.00
    2.50
    3.00
    3.00
    5.00

    I want to add 10% to everything in the above column to give:

    Price:
    1.10
    2.20
    2.75
    3.30
    3.30
    5.50

    The column has thousands of items so manual editing is not something I can complete this year ;-)

    If this involves some kind of formula would this prevent me from exporting as a CSV file - or would the CSV simply contain the numbers rather than the underlying formula?

    Apologies if this is a simple question but I am stumped :-?

    Any help appreciated!

    Thanks,

    S

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon ste5442

    ...and welcome to the forum!!

    Try this trick.
    Find an empty cell, and put in it 1.1.
    Right click the cell and select Copy.
    Next select the range where the number you want to affect are.
    Right click and select Paste Special.
    Under the Operation heading click Multiply and OK.

    Job done!

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ 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