Applying percentage to entire column


I’m a beginnger in using Excel 2013 here but i do know how to use the basic functions ie. (SUM, ROUNDUP etc…)

Is it possible to have a function that allows me to calculate various percentage value of cells in a column just by changing the top cell(head)?

For example:

Column A (from row 2 – 100) is prices of various things 

Column B (from row 2 – 100) is the discounted prices ie. (95%, 80%, 70%)

I want to insert a function value in Column B row 1 where i can change the percentage discounts and it will apply to the entire Column.

Note: I am using Excel 2013


By: Chase

Leave a Reply

Your email address will not be published. Required fields are marked *