Multiple options for if in a drop down menu [Closed]

Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
hello,
i trying to make a drop down list in which u can select food and it has a price so in the drop down list there is a3,a4 AND a5(in the drop down list its chicken, corn and bread) and i want to assign the values as a3 TO b3, a4 TO b4 AND a5 TO b5 using the if command/formula. also im using excel 2007 and in another system 2010,will it be different.
please respond as soon as possible
regards,
ed


1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
I think you need to use an ActiveX ComboBox to do this.
Example:

The Properties to do this are:


If you want to return another column in the data set you can use the "BoundColumn" field to select it.
In the example above a value of 2 was used.

But I need to use if, its for a project, the food are all on one column and the price on the next, a bill should be made at the end, that's why I need to give the food a value, but when I'm typing the formula it ask to give a value for false though dere is 3 options
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Show me what you have.