Type a formula in one cell and have other cells use the formula

Copper Contributor

I'm trying to make a template excel sheet for data analysis in one of my classes. For this data, I'll enter a few data points, get a trendline off of those data points and then run my other data through the trendline equation. I'm trying to figure out how to type the trendline equation in one cell and then have other cells reference the cell with the trendline equation to autopopulate the output based on my other data points.  I'm hoping to avoid having to copy paste the trendline equation into every single cell where my data is.

1 Reply