Need help with writing formula.

  • Thread starter Thread starter John1791
  • Start date Start date
J

John1791

I used an Excel chart to derive a trendline formula. Now I need to enter the
formula into Excel to calculate other data. But, I can not figure out how to
enter the formula in a cell to get a correct answer.

Can anyone help me?

I need: y = -1E-10x2 + 3E-05x - 0.015 to be pasted into a cell and take an
"X" and produce a "Y."

Example: if X = 36,000, then Y should be 1.01 (or really close)
 
Put your X value in A2, and then get your Y value in B2 using the formula
= -1E-10*A2^2 +3E-5*A2 - 0.015

With an X value of 36000 I get a Y result of 0.9354, not 1.01
 
Back
Top