"Peter T" wrote in message


I know that's not a 'stressful' test but could you illustrate when Linest
becomes unreliable and/or returns different coeff's to a high precision
chart formula.

Hmm, with a bit more testing I am getting discrepancies between Linest and
the chart formula, but it's the chart formula that's wrong (particularly
with the first x is not increasing from 1), Linest still returning same
coef's as the original formula (with no artificial deviation).

PT