| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Linest Function Bug | Excel Worksheet Functions | |||
| Reverse output of the Linest function | Excel Worksheet Functions | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| what is the max number of factors in Linest function | Excel Worksheet Functions | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
Threaded Mode
