LINEST and Y-intercept other than 0

[mrblister]

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.

 

[Tetra201]

... 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)

 

[mrblister]

Like this?

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

Yes, that seems to work. Thank You!

 

[Tetra201]

You are welcome.