+ Reply to Thread
Results 1 to 3 of 3

Add percentage to whole column

  1. #1
    Registered User
    Join Date
    03-20-2021
    Location
    Athens
    MS-Off Ver
    2016
    Posts
    8

    Add percentage to whole column

    Hey!! I want to add a percentage to a whole column without copy and pasting it to another column. eg get 15% more on a1, on a2 and etc. Any idea?? I know this is might too simple but cannot find the answer

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,849

    Re: Add percentage to whole column

    If you want to add 15% to all numbers, first type 1.15 into a cell. Then Copy that cell. Then select the cells you want to change, and Paste, Paste Special, Multiply.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-20-2021
    Location
    Athens
    MS-Off Ver
    2016
    Posts
    8

    Re: Add percentage to whole column

    Quote Originally Posted by 6StringJazzer View Post
    If you want to add 15% to all numbers, first type 1.15 into a cell. Then Copy that cell. Then select the cells you want to change, and Paste, Paste Special, Multiply.
    Really really thank you!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare words in a certain column from another column and get percentage
    By homer2211 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2021, 12:15 PM
  2. Replies: 7
    Last Post: 09-28-2017, 04:19 PM
  3. [SOLVED] percentage of parent column total - without using the column
    By verschelde.steven in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-03-2014, 05:45 AM
  4. Replies: 0
    Last Post: 11-20-2013, 11:28 AM
  5. Conditional Format an Entire Column based on percentage of another Column
    By Nolson24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 09:23 AM
  6. Percentage of a column --
    By barbagcl in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-05-2013, 01:53 PM
  7. Percentage of one column based on set data of another column
    By excelcaveman in forum Excel General
    Replies: 8
    Last Post: 07-17-2012, 03:30 AM

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