best option please

  • Thread starter Thread starter dido22
  • Start date Start date
D

dido22

Hello.

I have 30 separate calculations, each quite complex, which together depend
on 17 'Input' values. Each calculation results in a True or False value. I
am trying to find the Input values which maximise the total number of True
results.

I know how to count the number of True results OK, so I have a single
'target cell' whose value I want to maximise.

Snag .... All the numbers , all the calculations, all the inputs, are
Integers.

Can I do this via the 'solver', or 'what-if', or 'scenarios' or 'iterations'
?

Can someone point me in the right direction pls ?

Thanks

KK
 
Please post your 30 different calculations and 17 inputs and the
result you are looking from that. May be you will require Using IF
with AND and OR function.
 
Hello.

I have 30 separate calculations, each quite complex, which together depend
on 17 'Input' values. Each calculation results in a True or False value. I
am trying to find the Input values which maximise the total number of True
results.

I know how to count the number of True results OK, so I have a single
'target cell' whose value I want to maximise.

Snag ....     All the numbers , all the calculations, all the inputs,are
Integers.

Can I do this via the 'solver', or 'what-if', or 'scenarios' or 'iterations'
?

Can someone point me in the right direction pls ?

Thanks

KK
Click to expand...

Solver sounds like your best bet with that many possible inputs. It
might be useful if you can post your data, or you can send the file to
m DOT richardson DOT home AT gmail DOT com.

Matt
http://2toria.com
http://teachr.blogspot.com
 
Back
Top