View Single Post
  #1   Report Post  
David Adamson
 
Posts: n/a
Default Solver problem where 'IF Function' is bad

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



Eg 2

Salt in the water = 120

Salt Threshold = 100

Threshold violation = 20



Any tips would be greatly appreciated on how I can avoid using an If or
other non-smoth function would be greatley appreciated. AS this formula is
currently used in a table of 18*11.