Previous Topic Next Topic

Multiple options for if in a drop down menu

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


Related:

1 response

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
19 Feb 2016 à 21:35
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.
Teddy's photos
21 Feb 2016 à 04:03
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
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
21 Feb 2016 à 16:23
Show me what you have.

Similar discussions

How to boot proline laptop
REDX -
Thulisile -

3 responses
Proline w763s BIOS Resetting
Neo -
carminabigue -

1 response
Computer does not boot, stuck in bios boot screen
navin.rahim -
Thulisile -

8 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses