Flintstone's formula would allow you to check to see if Solver returned
one of the desired values. As for constraining solver to one of those
values, I didn't readily see how to do it. I tried setting a
constraint that Flintstones formula = TRUE, but it just gave me an
error.

Are those the only seven possibilities? If I only had seven choices to
choose from, I'd probably do it by hand. Evaluate my
formula/spreadsheet for each of the seven inputs and use the computer
between my ears to determine which of the inputs satisfied my
criteria.

Alternatively, it could be set up over seven rows or sheets (depending
on complexity), then use MAX(), MIN(), or some other combination of
worksheet functions to extract the desired outcome.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=376929