Reference Formula and cell reference

ImAhNoBoDy · #1 10-12-2024, 10:28 PM

I have a spreadsheet that is based on benching (weight lifting). The cells currently increase by 5lbs everyday. By day 4 the weight increases by 2.5lb everyday. In Day 5, I never copied the new formula from day 4 to the rest of the days ahead, so day 5 is increasing by 5lb and that's not what I want. It should be increased by 2.5lb everyday.

Is there a formula I could use that would reference the previous day and increase the weight appropriately without copying the formula everytime the weight increase is changed?

I wasn't sure if FORMULATEXT was appropriate and tried searching for a solution to this and couldn't come up with something. Any help would be appreciated. Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining if an in-text table reference was created with Word's native cross reference feature	scienceguy	Excel Programming	2	10-25-2021 04:44 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
Issue with a dynamic cell linking/reference formula	raravind82	Excel	2	10-26-2016 04:16 AM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM