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:


cellContent(1,5): when isDefined(this.cellNumericValue(1,2)) and isDefined(this.cellNumericValue(1,3)) and isDefined(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.

Ohh, thank you for the suggestion!