Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general,microsoft.public.office.developer.vba
|
|||
|
|||
how to find root in Excel/VBA?
Let's say I want to use Newton's root finding method:
I've already programmed my function in VBA, now I want to use Newton's method to find the root of that function in VBA... I am guessing that in Excel it has built-in function to do this, But what is that root-finding Newton's function and how to use that Excel built-in function in VBA? Thanks a lot |
#2
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general,microsoft.public.office.developer.vba
|
|||
|
|||
how to find root in Excel/VBA?
Maybe we have a simpler way to do the Newton's rootfinding:
Let me describe my current situation more clearly: Currently in my Excel worksheet, Depending on a parameter "y" in Cell(12, 2), When we click a button "GO", in Cell (13, 2) I will get a number(from a function call to VBA macro, which I wrote previously), Cell(13,2) is the function value which changes along with the "y" value in Cell(12, 2). Now I want to use the Newton's method in Excel, to find the parameter "y" to get the Cell(13,2)'s function value to be equal to 100. I want the correct "y" value to be found by Newton's method and displayed back in Cell(12, 2) and I want the iterative procedure(i.e. the function values at each root finding procedure) to be displayed and highlighted somewhere in the Worksheet also. I guess I can do this simply in Excel based on my function already written in VBA... How to do that? Thanks a lot "cfman" wrote in message ... Let's say I want to use Newton's root finding method: I've already programmed my function in VBA, now I want to use Newton's method to find the root of that function in VBA... I am guessing that in Excel it has built-in function to do this, But what is that root-finding Newton's function and how to use that Excel built-in function in VBA? Thanks a lot |
#3
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general,microsoft.public.office.developer.vba
|
|||
|
|||
how to find root in Excel/VBA?
Have you looked at the ToolsSolver ?
Requires the Solver addIn installed. NickHK "cfman" wrote in message ... Maybe we have a simpler way to do the Newton's rootfinding: Let me describe my current situation more clearly: Currently in my Excel worksheet, Depending on a parameter "y" in Cell(12, 2), When we click a button "GO", in Cell (13, 2) I will get a number(from a function call to VBA macro, which I wrote previously), Cell(13,2) is the function value which changes along with the "y" value in Cell(12, 2). Now I want to use the Newton's method in Excel, to find the parameter "y" to get the Cell(13,2)'s function value to be equal to 100. I want the correct "y" value to be found by Newton's method and displayed back in Cell(12, 2) and I want the iterative procedure(i.e. the function values at each root finding procedure) to be displayed and highlighted somewhere in the Worksheet also. I guess I can do this simply in Excel based on my function already written in VBA... How to do that? Thanks a lot "cfman" wrote in message ... Let's say I want to use Newton's root finding method: I've already programmed my function in VBA, now I want to use Newton's method to find the root of that function in VBA... I am guessing that in Excel it has built-in function to do this, But what is that root-finding Newton's function and how to use that Excel built-in function in VBA? Thanks a lot |
#4
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general,microsoft.public.office.developer.vba
|
|||
|
|||
how to find root in Excel/VBA?
cfman -
Have you tried Tools | Goal Seek ? - Mike http://www.mikemiddleton.com "cfman" wrote in message ... Let's say I want to use Newton's root finding method: I've already programmed my function in VBA, now I want to use Newton's method to find the root of that function in VBA... I am guessing that in Excel it has built-in function to do this, But what is that root-finding Newton's function and how to use that Excel built-in function in VBA? Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find cubed root of a number | Excel Worksheet Functions | |||
Can you find the cubed root on excel | Excel Worksheet Functions | |||
In Excel, how do I insert a formula to find the 5th root of a no. | Excel Worksheet Functions | |||
In excel how do you find the cubic root of a number? | Excel Worksheet Functions | |||
How do I find root mean square of a periodic data in Excel | Excel Discussion (Misc queries) |