I'm not the most savvy Excel user, so this may be something I'm trying
to do that's over my head, but I'm willing to learn as best I can.
I'll try to be as clear as possible on this one.

The formula that I'm trying to accomplish sets limits min/max to the
final value of a number that is outputted. So, if the final output is
100, but based on a set of rules, the value's max is only 90, then the
formula will only allow the final output to be 90....same for the
reverse, if the final output is 20, but the minimum allowed output is
50, then the final output will show the number 50.

Example:
I have a set of value settings:

Variable setting -- Min -- max restrictions
1 -- 0 --10
2 -- 5 -- 15
3 -- 8 -- 20
4 -- 10 -- 30
5 -- 20-- 60

Case1: final output is 30, but within the parameters it is set to
Variable#3, so...the highest number possible is 20....thus, the output
becomes 20 rather than30.

Case2: the final output is 10, but within the parameters, it's set to
Variable#5. The lowest value there is 20, so the output then becomes
20 rather than 10, because of the restrictions.

If I'm making no sence, let me know, I'll try to be more clear.

Thanks for the help in advance.

Owen


--
webadict2be
------------------------------------------------------------------------
webadict2be's Profile: http://www.excelforum.com/member.php...o&userid=31236
View this thread: http://www.excelforum.com/showthread...hreadid=509023