Go to this section of a workshee if M2="Y" go to O2-U2 if "N" go t

  • Thread starter Thread starter Kevin W
  • Start date Start date
K

Kevin W

I am trying to make a question sheet with two sets of variables or questions.
If a user enters a Yes or Y in M2 then go to O2-U2 if M2 = No or N go to V2-Y2
 
What is user inputs none of the above? Perhaps, leave cell blank?

=IF(OR(M2="yes",M2="Y"),O2-U2,IF(OR(M2="No",M2="N"),V2-Y2,""))
 
Back
Top