Thread: How to find percentage of columns data in Excel

1. Member
Join Date
Dec 2011
Posts
69

How to find percentage of columns data in Excel  Reply With Quote

2. Member
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.  Reply With Quote

3. Member
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.  Reply With Quote

microsoft, microsoft excel, worksheet, percentage, excel table cell, excel table column 