MATH TRICKY PROBLEM
- Thread starter igorsusa
- Start date
Asheesh
Excel Ninja
Hi Igorsusa..
First of all welcome to the forum...
you are getting negative values in cells which are highligted in blue because these values are dependent on values in J & K...and column K holds negative numbers...
I would suggest you to use ABS to wrap your formulae in blue cells..this will always lead to a positive result..
First of all welcome to the forum...
you are getting negative values in cells which are highligted in blue because these values are dependent on values in J & K...and column K holds negative numbers...
I would suggest you to use ABS to wrap your formulae in blue cells..this will always lead to a positive result..
Hi igorsusa,
I understand you can only change the values in yellow.
At the same time you may have to think that values in "K" which is currently negative is derived from B1- SL or B2-SL, etc, it is a formula, but your file is not have the formula.
When you were instructed not to change anything apart from yellow, I suppose they mean not to change the formulas in other cells. By viewing your file I feel they have clearly stating how the values are arrived.
Also, column A to H is going to be what you would give as value for B1 to B3, S1 to s3 etc.
The only missing piece i see here is what is defined for SL and TP.
If you provide the background of this requirements, it may be easier to solve.
Else, no maths can make Negative a positive (unless multiplied with another negative), but in the spreadsheet, input of negative will also not help as there are other dependent cells with positive value.
Regards,
Prasad DN.
I understand you can only change the values in yellow.
At the same time you may have to think that values in "K" which is currently negative is derived from B1- SL or B2-SL, etc, it is a formula, but your file is not have the formula.
When you were instructed not to change anything apart from yellow, I suppose they mean not to change the formulas in other cells. By viewing your file I feel they have clearly stating how the values are arrived.
Also, column A to H is going to be what you would give as value for B1 to B3, S1 to s3 etc.
The only missing piece i see here is what is defined for SL and TP.
If you provide the background of this requirements, it may be easier to solve.
Else, no maths can make Negative a positive (unless multiplied with another negative), but in the spreadsheet, input of negative will also not help as there are other dependent cells with positive value.
Regards,
Prasad DN.
NARAYANK991
Excel Ninja
Hi Igor ,
Like most of the others I am also convinced that the problem as given does not have a solution ; it is possible there is some typographical error somewhere.
Going by what is given in column L , the equations are :
B1 - TP = 3
B2 - TP = 2
B3 - TP = 1
S1 - TP = -4
S2 - TP = -5
S3 - TP = -6
B1 - SL = -4
B2 - SL = -5
B3 - SL = -6
S1 - SL = 3
S2 - SL = 2
S3 - SL = 1
If we now rearrange all of the equations in terms of TP and SL , we get :
B1 = TP + 3 .............. and ......... B1 = SL - 4
B2 = TP + 2 .............. and ......... B2 = SL - 5
B3 = TP + 1 .............. and ......... B3 = SL - 6
S1 = TP - 4 .............. and ......... S1 = SL + 3
S2 = TP - 5 .............. and ......... S2 = SL + 2
S3 = TP - 6 .............. and ......... S3 = SL + 1
Thus we have 2 sets of equations which can be used to relate TP and SL ; if we take the top set , we have :
TP + 3 = SL - 4
TP + 2 = SL - 5
TP + 1 = SL - 6
Using this set , we can see that :
TP = SL - 7
However , if we take the bottom set , we have :
TP - 4 = SL + 3
TP - 5 = SL + 2
TP - 6 = SL + 1
Using this set , we get :
TP = SL + 7
These 2 equations relating TP and SL are clearly contradictory.
Narayan
Like most of the others I am also convinced that the problem as given does not have a solution ; it is possible there is some typographical error somewhere.
Going by what is given in column L , the equations are :
B1 - TP = 3
B2 - TP = 2
B3 - TP = 1
S1 - TP = -4
S2 - TP = -5
S3 - TP = -6
B1 - SL = -4
B2 - SL = -5
B3 - SL = -6
S1 - SL = 3
S2 - SL = 2
S3 - SL = 1
If we now rearrange all of the equations in terms of TP and SL , we get :
B1 = TP + 3 .............. and ......... B1 = SL - 4
B2 = TP + 2 .............. and ......... B2 = SL - 5
B3 = TP + 1 .............. and ......... B3 = SL - 6
S1 = TP - 4 .............. and ......... S1 = SL + 3
S2 = TP - 5 .............. and ......... S2 = SL + 2
S3 = TP - 6 .............. and ......... S3 = SL + 1
Thus we have 2 sets of equations which can be used to relate TP and SL ; if we take the top set , we have :
TP + 3 = SL - 4
TP + 2 = SL - 5
TP + 1 = SL - 6
Using this set , we can see that :
TP = SL - 7
However , if we take the bottom set , we have :
TP - 4 = SL + 3
TP - 5 = SL + 2
TP - 6 = SL + 1
Using this set , we get :
TP = SL + 7
These 2 equations relating TP and SL are clearly contradictory.
Narayan
udprocks
Member
I was told that there is a solution and that there must be real numbers and not just zeros.... But I wont take it for granted, because from the guy I get the file from he is also not sure if there is any solution...
really any solution for this..??? i am exciting to see the solution...