If then on drop down

  • Thread starter Thread starter Cam
  • Start date Start date
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?
 
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

variable question 3
Seeding in Drop Down List 3
Date Calculations as Days 6
Can I add more than 2 comparisons to an IF statement?? 3
Conditional Formatting across many cells with a mobile comparison 2
Macro Runtime Error 1004... help? 6
Figuring 24 Hours Per Day 5
CREATE FORMULA IN EXCEL 2

Back
Top