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

Iterative Formula

  • May 2, 2018
  • 2 replies
  • 2391 views

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

Best answer by Fred_Kohlhepp

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

2 replies

F
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.

D
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

T
21-Topaz II
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

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

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

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

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

      Terms & ConditionsCookie settingsAccessibility statement