Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on setting up excell to solve a math problem
Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is no
way to solve this algabraically that I am aware of. Thank You, Frank |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on setting up excell to solve a math problem
Tools/ Goal Seek.
-- David Biddulph "frank c" <frank wrote in message ... Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is no way to solve this algabraically that I am aware of. Thank You, Frank |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on setting up excell to solve a math problem
Maybe using Goal Seek?:
With B1: 1 A1: =((1+B1)^5)/B1 (Note: at that point A1 returns 32 Fom the Excel main menu: <tools<goal seek Set cell: A1 To value: 1555.2 By changing cell: B1 Click [OK] Goal Seek returns a solution of: 5 Does that help? *********** Regards, Ron XL2002, WinXP "frank c" wrote: Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is no way to solve this algabraically that I am aware of. Thank You, Frank |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on setting up excell to solve a math problem
Another option might be the Newton equation. Taking Ron's excellent
example, we can find the other two real solutions. '// Given y, solve for x with an initial guess for x. Function MyFx(y, x) Dim j For j = 1 To 20 x = (x * ((3 * x - 2) * (x + 1) ^ 4 + x * y)) / ((x + 1) ^ 4 * (4 * x - 1)) Next j MyFx = x End Function Sub TestIt() Debug.Print MyFx(1555.2, -5) Debug.Print MyFx(1555.2, 0.0001) Debug.Print MyFx(1555.2, 5) End Sub Returns the 3 Real solutions: -7.50826391236509 6.45080740534675E-04 5 -- HTH :) Dana DeLouis Windows XP & Office 2003 "Ron Coderre" wrote in message ... Maybe using Goal Seek?: With B1: 1 A1: =((1+B1)^5)/B1 (Note: at that point A1 returns 32 Fom the Excel main menu: <tools<goal seek Set cell: A1 To value: 1555.2 By changing cell: B1 Click [OK] Goal Seek returns a solution of: 5 Does that help? *********** Regards, Ron XL2002, WinXP "frank c" wrote: Is there a way to solve Y=((1+x)^5)/x with Y known in excell? There is no way to solve this algabraically that I am aware of. Thank You, Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basic question on typing names on spreadsheet- problem | Excel Discussion (Misc queries) | |||
Question regarding dynamic range setting | Excel Worksheet Functions | |||
I have question.. I have problem with Cells.find | New Users to Excel | |||
Date Math Problem | Excel Worksheet Functions | |||
Math Question | New Users to Excel |