I am still having trouble doing the skips. I duplicated the questions (calling them Mxb where the original is Mx. it seems to be very complex- there are 18 questions, and I want the quex to skip to the first one that they skip (after they've gone through the original once). I duplicated the questions (calling them Mxb where the original is Mx. That means if they skip question 15 first, ML will need to search questions 1-14 before detecting that they ahve skipped question 15. I've tried to write a code for this, but It doesn't seem to work past the first skip (e.g. the M1=5, "M1b" skip works but nothing esle). I am pasting it below- can you let me know how I can fix it (I am by no means good with computer code)? I put it in the "skip 1 column":
IF (M1=5, "M1b") IF (M1>5 and M2=5, "M2b") IF (M1<5 and M2<5 and M3=5, "M3b") IF (M1<5 and M2<5 and M3<5 and M4=5, "M4b") IF (M1<5 and M2<5 and M3<5 and M4<5 and M5=5, "M5b") IF (M1<5 and M2<5 and M3<5 and M4<5 and M5<5 and M6=5, "M6b")
That was all I could fit in Skip 1 so I put the following into Skip 2 (not that it matters b/c it didn't work past the first skip anyway!)
IF (M1<5 and M2<5 and M3<5 and M4<5 and M5<5 and M6<5 and M7=5, "M7b") IF (M1<5 and M2<5 and M3<5 and M4<5 and M5<5 and M6<5 and M7<5 and M8=5, "M8b") IF (M1<5 and M2<5 and M3<5 and M4<5 and M5<5 and M6<5 and M7<5 and M8<5 and M9=5, "M9b")




Reply With Quote