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. If the forum does permit you to post a URL (yet), spell it out manually. 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).
