yep, it was zero.
he didn't say (in this post) what answer he was expecting, just that
it wouldn't let him enter the formula. i was simply saying i had been
able to duplicate his error.
........... bowing out now (semi-gracefully).
:)
susan


On Dec 27, 11:05*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Yes, it does mean the same as the first one, Susan, but if the answer that
comes out is -0.011, then you don't have 36000 in A2. * [You presumably have
zero?]
With 36000 in A2, the answer is 0.95236. *If the OP is expecting 1.01, then
my guess is that he doesn't have enough significant figures in his
polynomial coefficients.
--
David Biddulph

"Susan" wrote in message

...
i admit i have no idea what this formula does, but when i copy

= -9e-11*A2^2 + 3e-5*A2 - 0.011

into a cell & hit enter, it turns it into:

= -0.00000000009*A2^2 + 0.00003*A2 - 0.011
which shows a value of -0.011.
...
On Dec 27, 10:05 am, Mike H wrote:



John,

I assume you mean David's reply. If you do the answer he gave you is a
valid
solution to this latest question. i.e.

= -9e-11*A2^2 + 3e-5*A2 - 0.011
"John1791" wrote:
The reply worked, but I had to redo my formula and develop a new
formula.
The new formula is: y = -9E-11x2 + 3E-05x - 0.011 Now, Excel will not
let me
enter it as Excel will not let me continue because Excel insists that I
change the -9E to the cell address of "E9."

Can anyone help me write this formula so that Excel will accept it.

THank you very much.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -