How can I use chart trendline equation in worksheet cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-2060232%22%20slang%3D%22en-US%22%3EHow%20can%20I%20use%20chart%20trendline%20equation%20in%20worksheet%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060232%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20assist%20with%20my%20formula%20request.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2060232%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060401%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20use%20chart%20trendline%20equation%20in%20worksheet%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928868%22%20target%3D%22_blank%22%3E%40Roma_1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2019%2F01%2F16%2Fexcel-trendline-types-equations-formulas%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20trendline%20types%2C%20equations%20and%20formulas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2073815%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20use%20chart%20trendline%20equation%20in%20worksheet%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2073815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20I%20finally%20took%20a%20good%20look%20at%20the%20trendline%26nbsp%3B%20%26amp%3B%20formula%20and%20got%20to%20use%20the%20polynomial%20formula%20y%20%3D%20index(linest(....)%20and%20believe%20I%20can%20solve%20my%20problem.%20This%20will%20reduce%20my%20if%20and%20Vlookup%20formula%20from%201%20page%20to%20a%20few%20lines%2C%20and%20will%20be%20more%20simple%20to%20debug.%20Many%20thanks%20Hans%20%26amp%3B%20Microsoft.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please assist with my formula request.

2 Replies

@Hans Vogelaar  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.