Excel's Goal Seek Equivalent

I would like to solve the following equation such that the variable, hf, satisfies it:
F = J1 * J2 * (((1 - exp(-a7*hf))/a7) + (H2*(1-exp(-a7*hf)-(a7*hf*exp(-a7*hf))))/(a7^2));
Where a7 is a numerical data value computed in a separate script, H2 is a numerical value imported from Excel and F, J1 and J2 will be defined before this function call.
Example values that I have determined by hand (with rounding) are such: If, J1 = 57.259, F = 592.9, J2 = 3.256, H2 = 7, a7 = 0.4, then hf = 0.936.
Is there a way to solve this equation in a similar manner to Excel's goal seek?
Thank you

1 件のコメント

Walter Roberson
Walter Roberson 2012 年 2 月 5 日
http://www.mathworks.com/matlabcentral/answers/3608-goal-seeking

サインインしてコメントする。

回答 (0 件)

質問済み:

2012 年 2 月 5 日

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by