Articles

Convert trendline equations into formulas in Excel easily

We've all been there, you've created a graph in excel, needed to smooth or extrapolate the data so have resorted to doing a quick and dirty trendline. 1 2 =trendlineparse("y = 2.6948ln(x) - 0.4039 ",2)   Public Function TrendlineParse(Eqtn As String, Optional xVal As Variant = "eq", Optional xType As Variant = 0) As Variant    more »