Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help with determining a formula
open a spreadsheet and place the following value(s)...
(cell A1) $50000 ..., this entry represents a fixed dollar amount (cell B1) 0.025 ..., this entry represents a "rate" (cell C1) 25 ..., this entry represents a fixed amount of years (cell D1) 0.020 ..., this entry represents a seperate "rate" (cell E1) 5 ..., this entry represents additional amount of years (cell F1's formula) =(A1*B1*C1)+(A1*D1*E1) ..., this produces $36250 (cell G1's formula) =F1/A1 ..., this produces 72.5%, (or .0725) (cell H1's formula) is where I need help? I cannot deterime the formula that will report, "What amount of total years will produce a result of 78% (.078) in G1's cell? 25 plus "whatever" additional years? P.S. (C1+E1)/G1*.78 does not produce the correct formula/answer. I know that the correct answer is, 32.75 (years) or otherwords 7.75 in E1's cell, but I cannot figure out the formula that will provide that answer! Thanks for your help... - rudy |
#2
|
|||
|
|||
need help with determining a formula
If I were good at maths I could answer this, but alas, I'm not, however: your 72.5% in G1 is composed of 43103.54 being (A1*B1*C1) (and A1) at 72.5% and 6896.55 being +(A1*D1*E1) (and A1) at 72.5% The 36250 is 31250 + 5000 of which 31250 will not change by adjusting column E, so to calculate column E is then (A1 * .78 ) = 39000 (column F) of which you have 31250, thus you need 7750 If +(A1*D1*E1) needs to be 7750 then E1 = 7750 / (A1 * D1) or something like that. Hope this helps Cal Wrote: open a spreadsheet and place the following value(s)... (cell A1) $50000 ..., this entry represents a fixed dollar amount (cell B1) 0.025 ..., this entry represents a "rate" (cell C1) 25 ..., this entry represents a fixed amount of years (cell D1) 0.020 ..., this entry represents a seperate "rate" (cell E1) 5 ..., this entry represents additional amount of years (cell F1's formula) =(A1*B1*C1)+(A1*D1*E1) ..., this produces $36250 (cell G1's formula) =F1/A1 ..., this produces 72.5%, (or .0725) (cell H1's formula) is where I need help? I cannot deterime the formula that will report, "What amount of total years will produce a result of 78% (.078) in G1's cell? 25 plus "whatever" additional years? P.S. (C1+E1)/G1*.78 does not produce the correct formula/answer. I know that the correct answer is, 32.75 (years) or otherwords 7.75 in E1's cell, but I cannot figure out the formula that will provide that answer! Thanks for your help... - rudy -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=484171 |
#3
|
|||
|
|||
need help with determining a formula
You could do this with goal seek. But if you want the equation, =(0.78 -
B1*C1)/D1 "Cal" wrote: open a spreadsheet and place the following value(s)... (cell A1) $50000 ..., this entry represents a fixed dollar amount (cell B1) 0.025 ..., this entry represents a "rate" (cell C1) 25 ..., this entry represents a fixed amount of years (cell D1) 0.020 ..., this entry represents a seperate "rate" (cell E1) 5 ..., this entry represents additional amount of years (cell F1's formula) =(A1*B1*C1)+(A1*D1*E1) ..., this produces $36250 (cell G1's formula) =F1/A1 ..., this produces 72.5%, (or .0725) (cell H1's formula) is where I need help? I cannot deterime the formula that will report, "What amount of total years will produce a result of 78% (.078) in G1's cell? 25 plus "whatever" additional years? P.S. (C1+E1)/G1*.78 does not produce the correct formula/answer. I know that the correct answer is, 32.75 (years) or otherwords 7.75 in E1's cell, but I cannot figure out the formula that will provide that answer! Thanks for your help... - rudy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |