Morning....How van I achieve the following...
column C, D and column E has different numerical values.
column D is calculated on the basis of cell T1 and column E on the basis of cell T3.
Colum C is just hard input.
Column F is a value (4 or -4) calculated on the basis of column D and column E.
T1 and T3 can only be between 1 - 100
Column G is calculated as follows...ex. G10 is calculated using values from C9, F9, F8 and G9.
Assume G100 is ex. 500.
Changes in T1 and T3 will ultimately lead to a change in G100.
How can I alter T1 and T3 in order to give the largest value for G100.
So I need to find the combination for T1 and T3 that will give the largest value for G100.
any ideas?
column C, D and column E has different numerical values.
column D is calculated on the basis of cell T1 and column E on the basis of cell T3.
Colum C is just hard input.
Column F is a value (4 or -4) calculated on the basis of column D and column E.
T1 and T3 can only be between 1 - 100
Column G is calculated as follows...ex. G10 is calculated using values from C9, F9, F8 and G9.
Assume G100 is ex. 500.
Changes in T1 and T3 will ultimately lead to a change in G100.
How can I alter T1 and T3 in order to give the largest value for G100.
So I need to find the combination for T1 and T3 that will give the largest value for G100.
any ideas?