View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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