Thanks for that suggestion Jerry, thats very useful.
I have been reading about the LINEST issues, fortunately it rarely applies
to how I am using it

Cheers

Incoherent

"Jerry W. Lewis" wrote:

Columns B and C are unnecessary, use
LINEST(D1:D5,A1:C5^{1,2,3})

You have resolved your actual question in this case, but there is an
issue with LINEST in 2003, such that coefficients that are exactly zero
are not to be trusted, although nonzero coefficients (other than assumed
intercept) are correct regardless.

http://groups.google.com/group/micro...e29a8e9b4382fa

Jerry