Is it possible for Solver to specify a criterion instead of a specific target value?

excelos

Active Member
Joined
Sep 25, 2011
Messages
329
Is it possible for Solver to specify a criterion instead of a specific target value?

For example, I want the target cell to be the maximum possible, below 100, and not a specific value.

Or is there any other tool?
 
Last edited:

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,838
Hi

You specify Max for the target cell and add the constraint that it's less than 100
 

Watch MrExcel Video

Forum statistics

Threads
1,109,054
Messages
5,526,507
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top