Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 07-01-2012
Member
 
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.
Reply With Quote
  #2  
Old 07-01-2012
Member
 
Join Date: Nov 2010
Posts: 420
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.
Reply With Quote
  #3  
Old 07-01-2012
Member
 
Join Date: Nov 2010
Posts: 502
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 12:04 AM.