The IF statement actually is a MAX(x-threshold,x) not that that helps
with Solver.

What does it mean the IF statement is "bad?"

What is the Solver model? The objective function? Are you maximizing
it? Minimizing it? What are the decision variables?

The formula you shared...what is it? How does it fit into the Solver
model.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
Solver problem where 'IF Function' is bad



What I'm looking at here is to determine if the salt level in the water
affects plant production.

What I had was



=(B181*(1-(B$130/100)*(IF($V56B$129,$V56-B$129,0))))



Written in English is

B181 = max yield

B130 = salt threshold slope

B129 = salt threshold

V56 = salt in the water



So yield = maximum yield * salinity impact

Where salinity impact = Slope * Threshold Violation



As the Solver model was trying to solve a global solution and the salinity
impact changes as the level of salt changes in the water the threshold may
or may not be violated.

I need to be able to change the Threshold Violation into a number and not an
'If Formula'. It doesn't matter if salinity impact is less than 1 but the
number should not exceed 1.



Eg 1

Salt in the water = 40

Salt Threshold = 100

Threshold Violation = 0