View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default array results not returned

JRM,

Are you using Ctrl-Shift-Enter instead of just Enter, and have your selecta a 6 column by 5 row area
prior to entering the formula?

HTH,
Bernie
MS Excel MVP


"JRM-drof" wrote in message
...
When using the LINEST formula in the array mode, I do not get the regression
statistics as promised by the formula when Stats is set to TRUE. I'm using
the example given in The Excel 2003 Article ID 829249.