USING DATA VALIDATION WITH CONDITIONAL LOGIC

  • Thread starter Data Validation AND Conditional Logic?
  • Start date
D

Data Validation AND Conditional Logic?

I have a list of audit questions. Answers are provided using drop down lists
via data validation lists.

Is there a way to auto populate answers based on a prior answer?
e.g. If the answer to question 33 is "No" I'd like the responses to
questions 34-40 to be "N/A"

I tried to use data validation (drop down list: Pass, Fail, N/A) AND
conditional logic (IF $I$33="No", "N/A",) but these options seem to be
mutually exclusive... true? Is there a way to use both features in the same
cell?

row 33 asks if a form was needed; if No, then questions 34-40 are
meaningless and should be N/A.

Thanks,

Bob
 
G

Gord Dibben

In cells I34-I40 enter a formula.

=IF($I$3="No","N/A", "result if false")


Gord Dibben MS Excel MVP
 

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

Top