Skip to main content
Dan34-Participant
4-Participant
May 2, 2018
Solved

Iterative Formula

Hi All,

 

I have written an iterative formula on pg 10 of the attached but cannot work out why it doesn't work. Could someone please give it a second look? Thank you in advance for your time and help.

 

Cheers,

Dan

Fred_KohlheppAnswer
23-Emerald I
May 3, 2018

Need to use functions.  See attached (yellow highlighted alterations.)

View in thread

6 replies

Fred_Kohlhepp23-Emerald I
23-Emerald I
May 2, 2018

If I right-click on your error and trace the error, I discover this:

Capture.PNG

I can't locate anywhere you define this variable.

Translate
Dan34-ParticipantAuthor
4-Participant
May 3, 2018

Hi Fred, 

 

Thank you for your reply. I am aware of this, but that error won't effect the find fuction on page 10.

 

Cheers,

Dan

Translate
terryhendicott21-Topaz II
21-Topaz II
May 3, 2018

Hi Dan

 

The missing value epsilon spotted by Fred appears in the second equation in the Solve block.

The Solve block will not solve without the value.

Cheers

Terry

Translate
    Fred_Kohlhepp23-Emerald IAnswer
    23-Emerald I
    May 3, 2018

    Need to use functions.  See attached (yellow highlighted alterations.)

    Translate
      Fred_Kohlhepp23-Emerald I
      23-Emerald I
      May 7, 2018

      Just to bring this back to the top of the garbage heap.

      Translate
      Terms & ConditionsAccessibility statement