Forum Discussion
Iterative calculations return #NUM
davididofff .... In English, the problem is: ``find a number such that 10 minus the number cubed is the number``.
Try the following system of formulas:
A1: =IF(A3="",0,IF(A2=0,A1,A1+1))
A2: =10-A1^3-A1
A3: empty, initially
Alternatively:
A1: =IF(A3="",0,IF(A2=A1,A1,A1+1))
A2: =10-A1^3
Enter anything into A3 to start the iterative calculation. Delete the value in A3 to start over.
For grins, change 10 in A2 to 2, 30, 68, 130, etc.
Remember to delete the value in A3 before changing A2. Otherwise, we get the wrong result because A1 does not start at zero.
davididofff .... In English, the problem is: ``find a number such that 10 minus the number cubed is the number``.
Try the following system of formulas:
A1: =IF(A3="",0,IF(A2=0,A1,A1+1))
A2: =10-A1^3-A1
A3: empty, initially
Alternatively:
A1: =IF(A3="",0,IF(A2=A1,A1,A1+1))
A2: =10-A1^3
Enter anything into A3 to start the iterative calculation. Delete the value in A3 to start over.
For grins, change 10 in A2 to 2, 30, 68, 130, etc.
Remember to delete the value in A3 before changing A2. Otherwise, we get the wrong result because A1 does not start at zero.
- Thanks! This works for me seems a bit complicated for such calculations but at least it works. Cheers!
