| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then on drop down
hi
assuming that your drop downs are data validation, i think there may be a problem with your formula. if in your formula, 30 is a real number then your formula should look like this...... =IF(AND(C8="Black",D8=30), "Yes","No") ie no quotes around the number 30. i tested and it works without the quotes. regards FSt1 "Cam" wrote: I have a sheet with a number of drop-down lists. I want to do an "if then" statement based on selections from the drop-downs but, it's not working. My formula is =IF(AND(C8="Black",D8="30"), "Yes","No"). It works as long as I type directly into c8 and d8. It does not work if I select c8 and d8 from a drop-down list. Do either of you know if I'm doing something incorrectly or can I just not do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating drop downs in a cell contingent on another drop down | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Threaded Mode
