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?
