Need help with writing formula.

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

David Biddulph

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
The reply worked, but I still need help.... 5
Excel trendline formula: capital E 4
Math formula help 5
Logical formatting for multiple values 1
Need formula for calculating time 2
Need help with a formula 3
Formula in Trendline 0

Top