Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Need to ad 10% plus 1 to a column

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Need to ad 10% plus 1 to a column. But I need to delete the orginal column.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Brian-123

    Type 1.1 in a spare cell, copy it, select your column and Paste, Special Values, Multiply. Then type 1 in a spare cell, copy it, select your column and Paste, Special Values, Add. That will increase the value of your cells by 10% then increase that value by 1.
    Afraid I do not follow why you would then want to delete the column.
    Hope this helps
    regards
    Derek

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-13 20:47, brian_123 wrote:
    Need to ad 10% plus 1 to a column. But I need to delete the orginal column.
    So you want to add 10% to a number, then add 1 to that number? Or do you want to add 110% to that number?

    If you want to add 10%, then add 1 to the new number, you can do this:

    in a blank cell, type 1.1

    copy that cell, then select your entire range that you want to add 10% to. Right-Click and select Paste Special (or go to Edit-Paste Special. In the Paste Special Dialog Box, under "Operation", select the multiply option. Click OK.

    Now type 1 in a blank cell (or the one you had 1.1 in) and do the same thing, except this time select the Add option in the paste special dialog box.

    No need to delete your original column, because it now reflects the changes!

    Hope this helps,

    Russell

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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