Excel Formula Syntax


I am trying to write the second formula on this page on excel (MVAR)


http://www.alternativesoft.com/modified_var.html

Up to now I did wrote this formula but something is wrong with it because it produces the wrong result

=(I5)-((-1.65+((1/6)*((-1.65^2)-1)*I8))+((1/24)*(-1.65^3*(-3*-1.65))*I7)-((1/36)*(2*-1.65^3-5*-1.65)*I8^2))*I6

awesomejohn19Asked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
I tried to bold one part of it.  It's the middle part z^3 - 3z
You wrote it as z^3 x 3z
0
 
cyberkiwiCommented:
=(I5)-((-1.65+((1/6)*((-1.65^2)-1)*I8))+((1/24)*(-1.65^3 - (-3*-1.65))*I7)-((1/36)*(2*-1.65^3-5*-1.65)*I8^2))*I6
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.