Ask Your Question

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

asked 2018-03-12 19:14:47 +0100

Matt- gravatar image

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:

image description

I want to have the Percentage Drop Down like this in D1 below:

image description

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.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-03-12 21:27:02 +0100

librebel gravatar image

Hello @Matt- ,

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

HTH, lib

edit flag offensive delete link more


Thank you so much librebel :D

It worked.

have a blessed day

Matt- gravatar imageMatt- ( 2018-03-14 00:01:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-12 19:14:47 +0100

Seen: 23 times

Last updated: Mar 12