Thread: trendline equations inserted directly to a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MrShorty[_32_] MrShorty[_32_] is offline
external usenet poster
  
Posts: 1
Default trendline equations inserted directly to a cell

LINEST and TREND can handle 3rd degree polynomials. Something like
LINEST(knownys,knownxs^{1,2,3},true). Or is there something else about
these functions that makes them unsuitable for your use?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=487317

Reply With QuoteReply With Quote