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

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

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

in b1 400
in b2datavalidationallow list10,20,30
in b3 =b1*(b2/100)

--
Don Guillett
SalesAid Software

"luke" wrote in message
...
i want to be able to change a value in excell by select ing a variety of
different % figures from a drop down box

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

Luke

Your value to change is in A1

Select B1 and DataValidationAllowList

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

In C1 enter =A1*B1


Gord Dibben MS Excel MVP

On Mon, 1 Jan 2007 05:34:00 -0800, luke wrote:

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