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

Easier way to concatenate a row? 8
count cell if value present in every other cell + criteria 2
Remove Formulas then Delete Cells based on conditions - XL2003 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Help with code please 4
Linking data between sheets to change color of cell? 2
cells formatted to tick when text value "Y" if or null if "N" 7
Dropdown list with a condition 2

Top