# LINEST and Y-intercept other than 0

#### mrblister

##### Board Regular
I'm using Linest to figure out the co-efficients for a quadratic equation for a set of X and Y points.

The formula looks like: LINEST(known_y's, known_x's^{1,2}
And I can get specific co-efficients using: INDEX(LINEST(known_y's, known_x's^{1,2}),ce_I_want)

To force the Y-intercept to 0, I would use: LINEST(known_y's, known_x's^{1,2}, FALSE).

But how do I force the Y-intercept to a number other than 0? For example, I would like to force the Y-intercept to 1.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
... how do I force the Y-intercept to a number other than 0? For example, I would like to force the Y-intercept to 1.
Like this?

=LINEST(known_y's-1, known_x's^{1,2}, FALSE)

shg
Like this?

=LINEST(known_y's-1, known_x's^{1,2}, FALSE)

Yes, that seems to work. Thank You!

You are welcome.

Replies
3
Views
392
Replies
3
Views
3K
Replies
7
Views
255
Replies
3
Views
681
Replies
3
Views
994

1,196,269
Messages
6,014,351
Members
441,816
Latest member
Klingon1960

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back