cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

SOLVED
Highlighted
Participant

## Finding which combination of values gives the highest/lowest result

I've been scouring the forums for a while now and I'm starting to come to the conclusion that either my question is so simple that nobody else needs to ask how to do it or that it just can't be done. Put simply, I'm trying to find out how I can get MathCAD (using Prime 4.0) to return the highest or lowest result of a function given a list of possible input variables.

For example, if I have a simple function:

`f(x,y) = x + y^2`

and a list of possible values for x and y:

```x = [3, -6, 2]
y = [2, 3, -3]```

How can I get MathCAD to output the largest (11) or smallest (-2) result?

1 ACCEPTED SOLUTION

Accepted Solutions

## Re: Finding which combination of values gives the highest/lowest result

Here are a few ways to do it

But I would prefer to write a utility function to do the job

Sometimes it may be a problem to have the function create the full matrix, so a different, a little bit more lengthy approach would do the same job:

Worksheet in format P4 attached

EDIT: I just remembered that there was a similar, but more coomplicated/demanding question here in this thread

There you can find a minmax function which will work with function with more than just two arguments. Not sure which version the file attached there is, but I guess the thread is old enough so the file should open with P4.

2 REPLIES 2

## Re: Finding which combination of values gives the highest/lowest result

Here are a few ways to do it

But I would prefer to write a utility function to do the job

Sometimes it may be a problem to have the function create the full matrix, so a different, a little bit more lengthy approach would do the same job:

Worksheet in format P4 attached

EDIT: I just remembered that there was a similar, but more coomplicated/demanding question here in this thread