Ask Your Question

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

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

edit retag close merge delete

## 1 Answer

Sort by » oldest newest most voted

Hello @Matt- ,

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

HTH, lib

more

## Comments

Thank you so much librebel :D

It worked.

have a blessed day

( 2018-03-14 00:01:30 +0100 )edit

## Stats

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

Seen: 31 times

Last updated: Mar 12