Solving a problem within VBA without using solver

[xodus8]

Is there any way to solve a problem within VBA without actually calling the excel solver function ? For example

f (a,b,c,d) = a^(1/2) + b^(1/3)+c^(1/4)+d(1^5)-5

f(a,b,c,d) should be 0 by changing the parameters a,b,c,d.

I know this can be done using solver, but I can not figure out the logic within VBA.

Thanks

 

[shg]

It has an infinite number of solutions ...

 

[xodus8]

oh yeah that's not a problem as long as I get a solution that works thats all I need

 

[mirabeau]

You have to start with any three of a, b, c, d as numerical values if you want to use Excel.

Say a=5, b=10, c=11 and then you can easily obtain a value (there may be more than one) for d.

These numbers must come from somewhere (where?) unless you're concerned only with the purely algebraic question of reducing a relation between 4 variables to a relationship between 3 variables. And Excel wouldn't usually be seen as the best, or even an adequate, way to do this.