#### acapro

##### New Member
Hi,

I want to add a couple of formulas that were provided to me by PGC however I am having trouble working out how to add them

Pcg provided me with the below
Hi

In that case you have a 2nd degree polynomial

y = a * x^2 + b * x + c

You can get the coefficients of the trendline:

a: =INDEX(LINEST(\$C\$3:\$C\$5,\$B\$3:\$B\$5^{1,2}),1)
b: =INDEX(LINEST(\$C\$3:\$C\$5,\$B\$3:\$B\$5^{1,2}),2)
c: =INDEX(LINEST(\$C\$3:\$C\$5,\$B\$3:\$B\$5^{1,2}),3)

and the Xmin

X= -b / (2 * a)

ABCDEFGHIJ
1
2XY
340022210a0.865X Min413.179
442022100b-714.8Y Min22059.757
544022682c169730
6
[Book1]Sheet2

<tbody>
</tbody>

What I have done is provided a link to view the actual sheet that I want to add it to (note the numbers are obviously different than PCGs)

https://jumpshare.com/v/a7G7ZlXjbSx4RDxV1sF3?b=0DdtSYr0hP0c6tGsqjvc

What I want the empty cells on the sheet (f29 and G29) to do is show the numbers that represent the lowest point of the red line (polynomial line) in PGC chart they are H3,I3 and H4,I3

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Replies
5
Views
311
Replies
3
Views
800
Replies
2
Views
2K
Replies
3
Views
1K
Replies
3
Views
284

1,196,308
Messages
6,014,578
Members
441,828
Latest member
cofracr

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