Multiple options for if in a drop down menu

Closed
teddys photos - Feb 19, 2016 at 04:52 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 21, 2016 at 04:23 PM
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 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 19, 2016 at 09:35 PM
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.
0
Teddy's photos
Feb 21, 2016 at 04:03 AM
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
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 21, 2016 at 04:23 PM
Show me what you have.
0