[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel Formula Syntax

Posted on 2011-02-24
2
Medium Priority
?
313 Views
Last Modified: 2012-06-27

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

0
Comment
Question by:awesomejohn19
  • 2
2 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 34973973
=(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
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 2000 total points
ID: 34973989
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question