Goal Seek (Emulating MS Excel)

[Jarvis]

Microsoft Excel has a function called "Goal Seek".

In this function you use a variable to affect a constant to produce a desired result.

For example: 15% X 200 = 30

In Goal Seek, each of these values is interchangeable.

You can select the desired end result or the desired variable and Goal Seek will produce the third value.

Goal Seek also allows the mathematical operators to be interchangeable.

Is there any way to do something like this inside Filemaker?

Thanks,

Jarvis

[Pupiweb]

Hello

Check this tip file by Mikhail Edoshin

http://edoshin.skeletonkey.com/2006/06/linked_fields.html#more

Ciao

G. Pupita

[Jarvis]

Thanks a lot G!