cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
amcknight
Community Member

Are conditional ("if") statements still an option for formula questions in New Quizzes?

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 --

IF(x-y,IF(1+(x-y)/ABS(x-y),-1,1),0)

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).

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.

Thanks for any help you can provide.

Labels (1)
0 Kudos
1 Reply
seisner
Community Member

I have the same question. I can set up the syntax, but get no meaningful result, even when I put in a simplistic test. And why has no one answered your question?? When I enter the formula if(0,1,100) it outputs 100, but when I use a defined variable, like if(n-5,1,100) it never outputs 100, en=ven when n = 5. I am at a loss.