USING DATA VALIDATION WITH CONDITIONAL LOGIC

[Guest]

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

 

[Gord Dibben]

In cells I34-I40 enter a formula.

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


Gord Dibben MS Excel MVP

 

[Guest]

try this website:

http://www.contextures.com/xlDataVal02.html

Nikki