Evaluating a formula using inputs from table

I have been trying and trying and trying! I want my students to enter 4 numbers and then use those to calculate the savings plan formula.

I’ve attached a picture of the table and the formula. Here’s the CL I used in the table:

Numerator=simpleFunction(“(1+(a/n))^(n*y)-1”,“a”,“n”,“y”)
Denominator=simpleFunction(“a/n”,“a”,“n”)

cellContent(1,5): when isDefined(this.cellNumericValue(1,2)) and isDefined(this.cellNumericValue(1,3)) and isDefined(this.cellNumericValue(1,4))

“${Numerator.evaluateAt(this.cellNumericValue(1,2),this.cellNumericValue(1,3),this.cellNumericValue(1,4))}”

otherwise “”

The cellContent(1,5) keeps displaying NaN. I’m going crazy with this! Any advice?
Screenshot 2023-02-13 223435
Screenshot 2023-02-13 223905

You don’t have proper latex notation for your function. The easiest way is to go into a math box in preview mode or a regular demos calculator, type your function, copy it, then paste to CL. It will show up as proper latex.

1 Like

Ohh, thank you for the suggestion!