Results 1 to 3 of 3

Thread: How to find percentage of columns data in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    69

    How to find percentage of columns data in Excel

    I know nothing about this and I am in a pickle. I don't even know where to type in the formula, so please spell it out for me in kindergarten language. I need a formula that will figure a percentage off. I have a column that is Retail Price and I need a formula that will auto fill 15% off the retail price of each cell in the previous column. However I don’t know much more about this so if you guys have any of the information or any of the suggestion then please do the reply. Your reply will be appreciated.

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: How to find percentage of columns data in Excel

    Assume your current retail price list is in the range A1:A10. In cell B1 enter this formula: =A1-A1*.15 with cell B1 still selected use your mouse and point to the little black square in the bottom right of the cursor. The fat "+" sign will change to a skinny "+" sign. And then Left click and hold then drag copy the formula down to A10.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: How to find percentage of columns data in Excel

    Since 100% is equal to one, 15% off can be represented as 100%-15%, or 1-15%, so if your retail price is in column A:
    B1: =A1 * (1-15%) which is also equivalent to B1: =A1 * 85%

    So, you can copy that formula in B1 down as far as necessary. May this will help you to percentage of columns data in Excel.

Similar Threads

  1. how to match data between 2 columns in excel
    By dankar in forum Windows Software
    Replies: 1
    Last Post: 25-04-2013, 11:16 AM
  2. Find the number of text repeated in columns of Excel
    By Jigisha in forum MS Office Support
    Replies: 4
    Last Post: 24-02-2012, 04:35 PM
  3. How to divide two different columns data in Excel
    By Chini mao in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 06:47 PM
  4. How to swap data between columns and rows in Excel
    By Rao's in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 05:46 PM
  5. Percentage problem on width of table columns
    By Zeverto in forum Software Development
    Replies: 3
    Last Post: 12-08-2009, 11:42 AM

Tags for this Thread

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
  •  
Page generated in 1,643,269,496.29044 seconds with 17 queries