If then on drop down

C

Cam

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?
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seeding in Drop Down List 3
Can I add more than 2 comparisons to an IF statement?? 3
IF information is in cell A8 then Formula is active? 1
Vlookup and multiple data 5
How to create 2 dependent drop down lists from 1 original drop dow 5
formula help 4
IF Statement in a macro: 2
Drop down list ???? 1

Top