Question

EXCEL 迭代计算

利用EXCEL进行迭代计算
问题

答案是

我是这么写的
((2*0.07677)/POWER((9.525*0.1821),1/3)*POWER((2*0.5175)/4.377*POWER(10,-4)*((((COS(RADIANS(11.76))/COS(RADIANS(N13)))-1))),1/2))-SIN(RADIANS((-51.2)+N13))

N13为要求的那个28.5 用单变量求 可是求出来结果四50多
请大家指教我问题出在哪里？
先谢谢大家了





Answer 1

=SIN(RADIANS((51.2-N13)))-((2*0.07667)/((9.25*0.1821)^(1/3)))*POWER(((2*0.5175-1)/(4.377*10^(-4)))*((COS(RADIANS(11.76)))/COS(RADIANS(N13))-1),1/2)
迭代结果是28.4093795280809

=SIN(RADIANS((51.2-N13)))-1.143*POWER((0.979/COS(RADIANS(N13)))-1,0.5)
迭代结果是28.5000027926598