Excel Linear Regression by set slope (not intercept)

Hi Guys
is there a way in excel to get the linear regression function to
specify a function based on a set intercept (say =1), instead of a set
intercept.

I believe this ability should have been included in excel from day 1.

Answered under your post in microsoft.public.excel.misc. Please do not
separately post the same question to multiple news groups.

"Ben" wrote:

> Hi Guys
> is there a way in excel to get the linear regression function to
> specify a function based on a set intercept (say =1), instead of a set
> intercept.
>
> I believe this ability should have been included in excel from day 1.
>
>