Forum Discussion
suchetalahiri
Jul 14, 2020Copper Contributor
Wrong cell reference
whenever I drag the cells, the cell reference change, and it gives wrong values. It happens with all the formula I use. I am now doing a course, and I am calculating the trend value. The attached wil...
- Jul 15, 2020
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.
Ardamilola
Jul 15, 2020MCT
suchetalahiri Try locking the first cell that references the source cell by using the "$" sign while referencing