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)?
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