problem with LINEST
 

[to:
microsoft.public.excel.misc, microsoft.public.excel.programming
]

hello,

why when i call makro some table formulas (LINEST) ignore
value in cell, in which i enter 1 or 0 (intercept value)

example is he http://miodek.no-ip.org/problem.xls

sheets 'model2'

regards

problem with LINEST
 

Can you describe the situation? Most people are hesitant to open workbooks
from unkown sources; particularly if they contain macros.

Jerry

"pm" wrote:

[to:
microsoft.public.excel.misc, microsoft.public.excel.programming
]

hello,

why when i call makro some table formulas (LINEST) ignore
value in cell, in which i enter 1 or 0 (intercept value)

example is he http://miodek.no-ip.org/problem.xls

sheets 'model2'

regards