Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek Algebra Formula
Hello everyone, ok, I've spent a little over two hours thinking about this
one, among the other dozen or so formulas I have managed to already solve. I was wondering if a few other braniac excel geniuses can tag along on this one. It's basically easy, somewhat, here it goes With a goal seek, all it would be is Change C by getting R to 15%, it drives for about 10 seconds and bam, solution. I need a formula to this for 40 rows instead of running goal seek each time, Is this possible? Now 15% is a formula based on the total of Sum(A:Z)/Receipt. Now each letter through A-Z is dependant on what C has, each cell in A-Z is a formula that depends on C. I hope that helps so far. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek Algebra Formula
hello too,
quite intriguing question...can u please post the basic formula u used to relate C with R... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Hello everyone, ok, I've spent a little over two hours thinking about this one, among the other dozen or so formulas I have managed to already solve. I was wondering if a few other braniac excel geniuses can tag along on this one. It's basically easy, somewhat, here it goes With a goal seek, all it would be is Change C by getting R to 15%, it drives for about 10 seconds and bam, solution. I need a formula to this for 40 rows instead of running goal seek each time, Is this possible? Now 15% is a formula based on the total of Sum(A:Z)/Receipt. Now each letter through A-Z is dependant on what C has, each cell in A-Z is a formula that depends on C. I hope that helps so far. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek Algebra Formula
Well actually this is what R is
=Total/Receipt Total=sum(A:Z) C is blank each cell in A-Z has this forumla (=IF(VLOOKUP(CONCATENATE($D1," ",$E1),$U$8:$AM$16,MATCH(AI$1,$V$7:$AM$7,0)+1,FALS E)0,IF($AJ1=0,0,ROUND(($AJ1/$AJ$3*AI$3)/$O1,0)*$O1),0)) except C, C is in that A-Z range. which in this formula its AJ1 Latter part of the formula which is performing the calculation after a Vlookup, goes to round(C/C's Index *A'sIndex/Pack)/Pack and so fourth to B to D, skipping C. "driller" wrote: hello too, quite intriguing question...can u please post the basic formula u used to relate C with R... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Hello everyone, ok, I've spent a little over two hours thinking about this one, among the other dozen or so formulas I have managed to already solve. I was wondering if a few other braniac excel geniuses can tag along on this one. It's basically easy, somewhat, here it goes With a goal seek, all it would be is Change C by getting R to 15%, it drives for about 10 seconds and bam, solution. I need a formula to this for 40 rows instead of running goal seek each time, Is this possible? Now 15% is a formula based on the total of Sum(A:Z)/Receipt. Now each letter through A-Z is dependant on what C has, each cell in A-Z is a formula that depends on C. I hope that helps so far. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek Algebra Formula
Javier,
I suggest u wait for some kinda macro for this "specific" one. i just can't realize if there's some kinda circ. ref. involve here... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Well actually this is what R is =Total/Receipt Total=sum(A:Z) C is blank each cell in A-Z has this forumla (=IF(VLOOKUP(CONCATENATE($D1," ",$E1),$U$8:$AM$16,MATCH(AI$1,$V$7:$AM$7,0)+1,FALS E)0,IF($AJ1=0,0,ROUND(($AJ1/$AJ$3*AI$3)/$O1,0)*$O1),0)) except C, C is in that A-Z range. which in this formula its AJ1 Latter part of the formula which is performing the calculation after a Vlookup, goes to round(C/C's Index *A'sIndex/Pack)/Pack and so fourth to B to D, skipping C. "driller" wrote: hello too, quite intriguing question...can u please post the basic formula u used to relate C with R... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Hello everyone, ok, I've spent a little over two hours thinking about this one, among the other dozen or so formulas I have managed to already solve. I was wondering if a few other braniac excel geniuses can tag along on this one. It's basically easy, somewhat, here it goes With a goal seek, all it would be is Change C by getting R to 15%, it drives for about 10 seconds and bam, solution. I need a formula to this for 40 rows instead of running goal seek each time, Is this possible? Now 15% is a formula based on the total of Sum(A:Z)/Receipt. Now each letter through A-Z is dependant on what C has, each cell in A-Z is a formula that depends on C. I hope that helps so far. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek Algebra Formula
That's what I thought, I was afraid of the circular reference, well If I
figure it out tonight I'll post it up. "driller" wrote: Javier, I suggest u wait for some kinda macro for this "specific" one. i just can't realize if there's some kinda circ. ref. involve here... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Well actually this is what R is =Total/Receipt Total=sum(A:Z) C is blank each cell in A-Z has this forumla (=IF(VLOOKUP(CONCATENATE($D1," ",$E1),$U$8:$AM$16,MATCH(AI$1,$V$7:$AM$7,0)+1,FALS E)0,IF($AJ1=0,0,ROUND(($AJ1/$AJ$3*AI$3)/$O1,0)*$O1),0)) except C, C is in that A-Z range. which in this formula its AJ1 Latter part of the formula which is performing the calculation after a Vlookup, goes to round(C/C's Index *A'sIndex/Pack)/Pack and so fourth to B to D, skipping C. "driller" wrote: hello too, quite intriguing question...can u please post the basic formula u used to relate C with R... regards, driller -- ***** birds of the same feather flock together.. "Javier Diaz" wrote: Hello everyone, ok, I've spent a little over two hours thinking about this one, among the other dozen or so formulas I have managed to already solve. I was wondering if a few other braniac excel geniuses can tag along on this one. It's basically easy, somewhat, here it goes With a goal seek, all it would be is Change C by getting R to 15%, it drives for about 10 seconds and bam, solution. I need a formula to this for 40 rows instead of running goal seek each time, Is this possible? Now 15% is a formula based on the total of Sum(A:Z)/Receipt. Now each letter through A-Z is dependant on what C has, each cell in A-Z is a formula that depends on C. I hope that helps so far. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I put Goal Seek into a cell formula? | Excel Worksheet Functions | |||
goal seek | Excel Discussion (Misc queries) | |||
Goal seek gone | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions |