Thread: CREATE SERIES OF PERCENTAGE OPTIONS 4 A VALUE. IN A DROP DOWN BOX
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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


Reply With QuoteReply With Quote