Looking for a way to calculate the minimum and maximum value of a formula .

M

McJe

Joined
Nov 17, 2008
Messages
4
Reaction score
0
I have a rather complex set of formulas, and they all are depending on a value 'x', which can vary between 0 and a certain value.

I need to find the maximum and minimum result of all these formulas, when x varies in its range.

It is possible to do this by searching derived functions, search for zero-crossings, ... But this makes my sheet very slow. I was wondering if it is possible to use a fast/standard/intelligent/... way of finding these values.

thanks!
Jeroen.
 
Back
Top