[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-core-devel
Subject:    Need help for KSpread Maths
From:       weis <weis () stud ! uni-frankfurt ! de>
Date:       1999-11-17 11:32:37
[Download RAW message or body]

Hi,

Excel has this "Goal Seek". Nice thing. You point it to a formular
and to the cell that is used as input and Excel finds the
input value that makes the formula result in a user specified value.

In fact that is the problem of finding x in f(x) = 0.

There are many algorithms which help you here, but they want
a) a range [a,b] to search in which can be very big with double values.
b) two points a and b, so that f(a)*f(b) < 0.

Can anyone tell me what to do here. Excel is getting quick and good
results, so there must be a way.

Bye
Torben

PS: No algebraic solutions.

[prev in list] [next in list] [prev in thread] [next in thread]