Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Excel Formula Syntax

Posted on 2011-02-24
Medium Priority
311 Views

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
Question by:awesomejohn19
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 2

LVL 58

Expert Comment

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

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

Question has a verified solution.

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

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!
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month9 days, 18 hours left to enroll

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

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