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).
