Forum Discussion
Roma_1
Jan 14, 2021Copper Contributor
How can I use chart trendline equation in worksheet cell?
Please assist with my formula request.
2 Replies
- Roma_1Copper Contributor
HansVogelaar I finally took a good look at the trendline & formula and got to use the polynomial formula y = index(linest(....) and believe I can solve my problem. This will reduce my if and Vlookup formula from 1 page to a few lines, and will be more simple to debug. Many thanks Hans & Microsoft.