best option please

[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

 

[Ms-Exl-Learner]

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.

 

[Matt Richardson]

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

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