View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DALLIN
 
Posts: n/a
Default How do I change the output value of a drop down box?

I want to create a drop down box that displays a rebar size. upon selection
of the size, in the output cell designated, I would like it to display the
area of that rebar size. I can't use a simple if statement because there are
10 different size and you can only use 7 nested if statement. what can I do?