Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to this section of a workshee if M2="Y" go to O2-U2 if "N" go t
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to this section of a workshee if M2="Y" go to O2-U2 if "N" go t
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,"")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kevin W" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |