I need help, I know Its got to be a simple fix, but...
I have a form where there are 20 questions. When a question is missed or marked NO I want the number of that question to appear in a comments section. So only questions where the answer is "no" appear in the comments section. Here is the problem. I have used the If function to get the first missed question no problem but when the second one occurs it only finds the first. What part of the formula am I missing? so if Question 1, in cell b1, is "no" I get the question number in a1, placed in a7 Ok. Here is the concern: if cell b1 is no and b2 is no I want cell a7 to be "1" and a8 to be "2" sequentially. I also want A7 to =2 if question 1 is "yes" but question 2 is "no".
I hope i have explained this correctly...
in cell a7 I have =if(b1=NO,a1,if(b2=no,a2,""))
Bookmarks