topic Are conditional ("if") statements still an option for formula questions in New Quizzes? in Question Forum
https://community.canvaslms.com/t5/Question-Forum/Are-conditional-quot-if-quot-statements-still-an-option-for/m-p/418410#M146412
<P>I have used "if" statements successfully in older Canvas quizzes, but for some reason, I have not been able to get New Quizzes to take this one --</P><P>IF(x-y,IF(1+(x-y)/ABS(x-y),-1,1),0)</P><P>I just want my students to be able to identify if a trend is decreasing (-1), stable (0), or increasing (1). New Quizzes is choking on something in the formula above, but I can't tell what (I've tried rewriting it in a number of ways).</P><P>Is this type of statement not an option in the new formula questions, or have I misremembered how to write it? Excel is my native formula-writing language, so that possibility is not too farfetched.<BR /><BR />Thanks for any help you can provide.</P>Sun, 25 Oct 2020 03:23:01 GMTamcknight2020-10-25T03:23:01ZAre conditional ("if") statements still an option for formula questions in New Quizzes?
https://community.canvaslms.com/t5/Question-Forum/Are-conditional-quot-if-quot-statements-still-an-option-for/m-p/418410#M146412
<P>I have used "if" statements successfully in older Canvas quizzes, but for some reason, I have not been able to get New Quizzes to take this one --</P><P>IF(x-y,IF(1+(x-y)/ABS(x-y),-1,1),0)</P><P>I just want my students to be able to identify if a trend is decreasing (-1), stable (0), or increasing (1). New Quizzes is choking on something in the formula above, but I can't tell what (I've tried rewriting it in a number of ways).</P><P>Is this type of statement not an option in the new formula questions, or have I misremembered how to write it? Excel is my native formula-writing language, so that possibility is not too farfetched.<BR /><BR />Thanks for any help you can provide.</P>Sun, 25 Oct 2020 03:23:01 GMThttps://community.canvaslms.com/t5/Question-Forum/Are-conditional-quot-if-quot-statements-still-an-option-for/m-p/418410#M146412amcknight2020-10-25T03:23:01Z