View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tbhakta tbhakta is offline
external usenet poster
 
Posts: 1
Default Multiple drop down list box

I want to create a drop down list with values
vx8500 with a value of $250.00
vx8600 with a value of $249.00
vx9900 with a value of $329.00
next would be to choose a plan catagory
$0.00-34.98 value of 180.00
$34.99-59.99 value of 280.00
next the price
so lets say 100.00

and at the end it will calculate the amount so if vx8500 was chose and plan
of 34.99-59.99

280.00(plan) - 250.00(cost) + 100.00(price paid for vx8500)

i also do not know how to put values for those items
so far i've got one drop down list

please help thank you