I need your help on something that’s been troubling me for a couple of days, I’m a Total Amateur at this Spreadsheet Game.
I want to put Drop Down Menu with Percentages that Calculates other Formulas from Different Cells.
let me explain:
I want to have the Percentage Drop Down like this in D1 below:
That Calculates the Percent of the Values in Column C and Show the Result in Column D.
But I have some formulas in the other cells to calculate aswel.
I have a formula in D2 to Calculate 2 percent of £100 in C2 (=C2*2%) Result: £2.00.
I add them together in a SUM Formula and show the Result in C3 (=SUM(C2,D2)). £102.00.
I utimately want every formula controled by the Percentage Drop Down Menu.
Is they anyway I can do this?
Thank you for your help.