Help with drop down box contents to be refered in a calculation.
Posted by Jammy Smith on November 13, 2000 6:02 AM
Ok. Help. I think I know how to create a drop down box. I then can refer it to say 3 cell contents so that the data is selectable using a combo box.
But where that cell where the drop down box is, the figures there, I require in a calculation.
I want to know how to refer the cell contents of a drop down box into a calculation.
Take a simple case. say cell A1 has a drop down box with 1,2 and 3 selectable. I want cell A2 to be =A1*2
I just need to know how to refer. That is all.
Taaa very much!