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?