Thread: Linest function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barna Barna is offline
external usenet poster
 
Posts: 1
Default Linest function

I am trying to nest other formulas into Linest with no success. I am trying
to set it up so users can change the range of cells that they want to run the
regression on without having to actually step into the formula.
This is an example of a formula:
=LINEST(Pivots!H28:H51,Pivots!F28:G51,TRUE,TRUE)
Can I embed another formula into Linest that would automatically change the
range?
Thank you,

Barna

PS: I am using Excel 2003