Need help with writing formula.
 

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)

Need help with writing formula.
 

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
--
David Biddulph

"John1791" wrote in message
...
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)