How to find percentage of columns data in Excel

[Kungfu Pandey]

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.

[Alfons]

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.

[Gania]

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.