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. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.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). Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Use trendline equation in excel