Need Help Please! ***Percentage Drop Down Menu***

[Matt2]

Hi Guys,

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.

Matt

[librebel]

Hello @Matt2 ,

In cell D2, just try the formula =C2*$D$1 ( then drag the small cell handle downwards );

HTH, lib

[Matt2]

Thank you so much librebel

It worked.

have a blessed day