Y= SomeTypeOfEvaluationFunction (“2.6667*x + 11. Y= SomeTypeOfEvaluationFunction (“2.6667*x + 11.44”) Excel allows you to customize your trendlines to better suit your data presentation: Format Trendline: Right-click on the trendline and choose ‘Format Trendline’ to access options like line style, color, and weight. Y= SomeTypeOfEvaluationFunction (TrendlineEquation) Can I evaluate this directly using some type of string evaluation function, and if so how? Or do I have to use the laborious string functions to extract the coefficients and recreate the function using variables? That is, I have can obtain the equation of a trendline as a string. Is there a method of evaluating this equation directly in VBA rather than using string manipulation functions to extract the numerical values in order to create a new function? However, can I evaluate this formula directly using some cool VBA function (see text from another posting)? Or do I need to use the laborious string functions?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |