View Single Post
 
Old 10-13-2024, 03:27 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

in the attached,
  • Adjust the green cells' values in row 4; this is the daily increase in weight (can be negative)
  • Adjust how long that increase should apply for in the green cells in row 2
  • Hide row 3
  • Change starting weight in cell C7
  • The formula in cell D7 is the one that can be copied across as far as you need.
  • Row 13 is only there to demonstrate how the weight increments have been applied, can be deleted.
There's probably a slicker way.
Attached Files
File Type: xlsx MSOfficeForums52907Benching.xlsx (12.0 KB, 5 views)
File Type: xlsx MSOfficeForums52907BenchingForExcel2010.xlsx (12.8 KB, 2 views)

Last edited by p45cal; 10-13-2024 at 02:22 PM.
Reply With Quote