Hi,
I am trying to extrapolate data from a graph with an exponential trendline using the trendline formula - but am no sure how to write the equation in a cell.
As you can see from the graph, the formula for the trendline is
How do i represent this in a cell?
I am wanting an exact value for 2021 - I have tried =0.0002*EXP(0.0074*2021) however this gives a value of 625.28 - which, looking at the graph is clearly incorrect.
Am I missing something?
Thanks
I am trying to extrapolate data from a graph with an exponential trendline using the trendline formula - but am no sure how to write the equation in a cell.
As you can see from the graph, the formula for the trendline is
How do i represent this in a cell?
I am wanting an exact value for 2021 - I have tried =0.0002*EXP(0.0074*2021) however this gives a value of 625.28 - which, looking at the graph is clearly incorrect.
Am I missing something?
Thanks