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

L

luke

i want to be able to change a value in excell by select ing a variety of
different % figures from a drop down box
 
G

Gord Dibben

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
 
Top