ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can we do this with solver (https://www.excelbanter.com/excel-discussion-misc-queries/122006-can-we-do-solver.html)

Amit

can we do this with solver
 
Hello everyone,

Could somebody please let me know if this is possible to calculate in
excel solver

If I have an equation in the form

D = h^a * k^b* L^c

h, k and L are know variables and a, b c are unknown variables within
limits

a <=2, b<=3 and c<=5,

Can I find a, b, c by using excel solver from some data D' Vs S where S
is also known variable and D is to be optimised for every S against D'.
Basicallt ecel solver gives me a, b and c for D to be closest to D'.

thanks
Amit



All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com