I have a spreadsheet which takes in certain parameters that I update every day. This is then inserted into a separate worksheet which holds all inserted data. I then use this data to take an average of the latest 5 entries to smooth out day to day variation: e.g.
=((B1*(100-(AVERAGE(Data!G$2:G$6))))/(343.805764))
When I insert a new data line, my formula updates to:
=((B1*(100-(AVERAGE(Data!G$3:G$7))))/(343.805764))
How can I prevent this update?