View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Calculation using a trendline

Hi,

Correct it's not an Eulier number it's just a notation Excel uses
10E2 is 10x10^2

Move to a cell and type 10E2
Move to another cell and type 10E-2

I think it will all become clear.

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"Chris" wrote:

When I calculate a trendline, I get a 6 degree polynomial. How do I calculate
a value using this formula? I have no idea how to compute the capital "E" - I
don't think it's Euler's number and it doesn't look like scientific notation
to me...

"y = -1E-07x^6 + 0.0016x^5 - 7.9878x^4 + 20857x^3 - 3E+07x^2 + 2E+10x - 8E+12
"
Thanks for your help!