Thread: Reference Formula and cell reference
View Single Post
 
Old 10-14-2024, 10:35 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by ImAhNoBoDy View Post
I would have to manually change the cell reference when the weight increase changes.
In the files I attached, adjust the green cells in row 2, you will immediately see the effect in row 7. If you want no change in weight for a period, put a zero in the appropriate green cell in row 4 and the number of days you want to stay at that weight in the corresponding green cell above it in row 2.


2024-10-14_184802.jpg
Reply With Quote