# Specifying coefficients in trendline equation

#### vinny21

##### New Member
Hi all!

I would like to know if there is a way to set a coefficient in the trendline equation to zero.

For example:
The equation of the second order trendline is Ax^2 + Bx + C
I want to find a way to set B = 0

I know it's possible to set C = 0 by setting the intercept, so I was wondering if there was such a thing for other coefficients.

(the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero)

Thanks

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
"the reason I want to do this is that I want to fit data to an equation where both the y and x intercepts are at zero"

If the Y intercept is zero, that means the equation goes through (0,0), which means the X intercept is already zero.

Replies
3
Views
102
Replies
7
Views
1K
Replies
1
Views
207
Replies
3
Views
2K
Replies
0
Views
1K

1,214,913
Messages
6,122,207
Members
449,074
Latest member
cancansova

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

### Which adblocker are you using?

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

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