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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking For A Formula 34
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Calculating a Formula Subject to a Maximum and Minimum Value 2
Omitting zeroes when looking for minimum values 2
Sum, Minimum and Maximum with a twist... 2
How can I calculate the minimum value of a VBA array? 4
Setting the minimum/maximum display range of a chart 3
Maximum and Minimum of a cell that changes 2

Top