Excel's Goal Seek Equivalent

조회 수: 7 (최근 30일)
Kaila
Kaila 2012년 2월 5일
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개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by