Alternatively, we can use LINEST to calculate the slope and intercept. The difference in the intercept (5.7594 instead of 5.7609) might be due to the different values of X and Y that I used and/or to insufficient precision in your presentation of the trendline formula.

The formula in B3 calculates the price, based on the data in A6:A11.įor clarity, I calculate the slope and intercept separated in D7:E7. Hopefully, the example in the attached Excel file and image below will be 'straight-forward' enough.ī3: =ROUND( SLOPE($B$7:$B$11, LN($A$7:$A$11)) * LN(A3) + Perhaps it is just the meandering and varied opinions, which I can image might be daunting. It is unclear what is not 'straight-forward' about the solution(s) in the discussion that you cite. For example, this thread is at techcommunity dot microsoft dot com /t5/excel/how-do-i-set-a-cell-equivalent-to-a-chart-trendline-equation/m-p/3589034. We can also use this equation to calculate the expected value of y, based on the value of x. If the forum does permit you to post a URL (yet), spell it out manually. Once we press ENTER, an array of coefficients will appear: Using these coefficients, we can construct the following equation to describe the relationship between x and y: y. You might like because it uses the same login as this forum. If the forum does not permit that (yet), upload the file to a file-sharing website and post the download URL here. Ideally, attach an example Excel file by clicking 'browse' at the bottom of a edit window. Quicker and better answers come when you include a concrete example. I hope there is a more straight forward solution. I have an excel chart that plots a logarithmic trendline based on a table with data For example, if the trendline equation is y=-0.407ln(x)+5.7609, I want the user to be able to enter an x value (quantity) in one cell and another cell outputs the corresponding y value (unit price).

Excel how to get equation of trendline