Reference Formula and cell reference
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.
|