CREATE SERIES OF PERCENTAGE OPTIONS 4 A VALUE. IN A DROP DOWN BOX

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to be able to change a value in excell by select ing a variety of
different % figures from a drop down box
 
in b1 400
in b2>data>validation>allow list>10,20,30
in b3 =b1*(b2/100)
 
Luke

Your value to change is in A1

Select B1 and Data>Validation>Allow>List

In the source dialog enter .10,.20,.30,.40,.50

In C1 enter =A1*B1


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

IF AND Nested Functions - Formula Not Working 0
Percentage Increase 13
customize drop-down box 1
Formatted cell column in drop down list 1
Protecting Sheets with drop down boxes 1
Drop down box issue 2
Drop Down list predicated on other drop down lists 2
drop down box code 2

Back
Top