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.

-----------------------
Ms-Exl-Learner
-----------------------


On Jul 9, 5:36*pm, "dido22" <nos...@nospam.hotmail.com> wrote:
> 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

On Jul 9, 1:36*pm, "dido22" <nos...@nospam.hotmail.com> wrote:
> 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