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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |