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

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
 
L

Luke M

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,""))
 

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

Similar Threads

VLookup IF word in string exists within cell, use the word. 0
Easier way to concatenate a row? 8
Circular Equation? wrap on 5 business days.. 1
count cell if value present in every other cell + criteria 2
If cell value = x or y then perform formula set else skip 3
Need a function to fill column from other columns 5
Using IF functiona and validation list 1
Stuck on Nested IF Function 2

Top