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

In cells I34-I40 enter a formula.

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


Gord Dibben MS Excel MVP

On Fri, 28 Sep 2007 08:30:04 -0700, Data Validation AND Conditional Logic? <Data
Validation AND Conditional wrote:

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

try this website:

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

Nikki

"Data Validation AND Conditional Logic?" wrote:

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