Forum Discussion
Trendline
I have always wondered, how do I replace the following formula to get the value of y? Like what is the formula in Excel for this so that if I replace x=23 I get y for example?
Click on Format Trendline (or box with the formula) and in formatting assign 17 decimal places, not 4 as you have now. Try formula again with updated parameters.
SergeiBaklan no difference at all.
How trendline formula looks after you changed the number of decimals?
SergeiBaklan the numbers have more decimals, but they are decimals, negligent enough to make a change on the final value.
