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)
|