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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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