Formulas with drop down list data

  • Thread starter Formulas with drop down list data
  • Start date
F

Formulas with drop down list data

I've entered a drop down list with percentages as options (5%, 10%, 15% etc.)
Is there a way to add a formula based on the selection in the drop down list?

I want the formula to multiply the percentage selected in my dropdown list
by the total amount in cell C63.
 
T

T. Valko

Just multiply the two.

A1 = drop down list cell

=A1*C63

--
Biff
Microsoft Excel MVP


"Formulas with drop down list data" <Formulas with drop down list
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change drop down list in one cell based on values in other cells 2
Drop-Down List 3
Filtered drop down list 2
please help (drop down list) 1
Double Drop-Down Validation in Excel 2007 1
Excel Excel: How do I put a formula in a drop down list 11
produce list automatically from choice of drop down list 1
Drop List + Formula 2

Top