cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

error formula quiz question

Jump to solution

I try to generate a question with a formula, in the step to define the formula I keep getting the following error message: "expecting a value at 1, got a equals". In Excel the formula works without fault. What does this error mean? What am I doing wrong?

just to be complete I've added my formula and the variable definitions below:

formula "=(k0*(1+((1+(iy/100/ix))^ix-1))^n)*(1+((1+(iy/100/ix))^ix-1)*q/365)"

variables k0 between 4000 and 50000

               iy between 1 and 10

               ix between 1 and 12

               n between 1 and 10

               q between 1 and 364

Tags (1)
1 Solution

Accepted Solutions
Community Coach
Community Coach

Hello merel.bergen@kdg.be...

I'll start out by saying that I'm not an instructor (I'm a Canvas administrator at our school), and I don't teach math courses...nor do I use the formula question type regularly.  So, my response may be completely off...in which case, I'm hopeful that someone else might be able to chime in.  But, I'm gonna give this a shot.  Please check out the following screen shot from my own sandbox course using your formula:

Formula Question

There are a few things I've highlighted:

  • First, notice at the top of the screen, all your variables need to be in the square brackets.  You may have your question configured this way already.
  • At the bottom, I believe your formula should look like what I've displayed above.  No equals sign needed to start.
  • The right column with the example values is what I think may have been causing the issue that you described...as I also saw that same message.  When I initially set up he question, there wasn't a number in that column for every row.  But, after I hit the "Recompute" button, numbers filled in, and the error message I saw went away.  So, I'm assuming that it will also go away for you, too.  (And, I can click on "Recompute" as much as I want to generate different numbers for all rows.)

I hope this will work for you, too, Merel.  Let Community members know if you have any questions...thanks!

View solution in original post

2 Replies
Community Coach
Community Coach

Hello merel.bergen@kdg.be...

I'll start out by saying that I'm not an instructor (I'm a Canvas administrator at our school), and I don't teach math courses...nor do I use the formula question type regularly.  So, my response may be completely off...in which case, I'm hopeful that someone else might be able to chime in.  But, I'm gonna give this a shot.  Please check out the following screen shot from my own sandbox course using your formula:

Formula Question

There are a few things I've highlighted:

  • First, notice at the top of the screen, all your variables need to be in the square brackets.  You may have your question configured this way already.
  • At the bottom, I believe your formula should look like what I've displayed above.  No equals sign needed to start.
  • The right column with the example values is what I think may have been causing the issue that you described...as I also saw that same message.  When I initially set up he question, there wasn't a number in that column for every row.  But, after I hit the "Recompute" button, numbers filled in, and the error message I saw went away.  So, I'm assuming that it will also go away for you, too.  (And, I can click on "Recompute" as much as I want to generate different numbers for all rows.)

I hope this will work for you, too, Merel.  Let Community members know if you have any questions...thanks!

View solution in original post

I think you hit it with the second item, Chris. There is no = at the beginning.