I have a formula that was generated by excel when using a trendline on a graph. I need to convert this formula into an excel formula I can use again.

the formula is below. Assume that the value for X will be in Cell A1. Any help converting this to an excel formula would be awesome. FYI = for a X value of 20,000, the formula should output something close enough to 20,000 ( +- 5 or 10k).

y = 1.8932x6

- 116.85x5 + 2669.5x4

- 27947x3 + 140531x2

- 298100x + 199955

## The Best Answer

Test the result according to the formular that you provide initially and get the result 16993.54 (B2=1) which it is should be.

=1.8932*B2^6 -116.85*B2^5 +2669.5*B2^4-27947*B2^3+140531*B2^2-298100*B2+199955

(The fomular you provide last time is different from your initial request.)

Cheers,

Tony Chen

Forum Support

Come back and mark the replies as answers if they help and unmark them if they provide no help.

If you have any feedback on our support, please contact

[email protected]