Reference Formula and cell reference

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
Reference Formula and cell reference

Prev

Previous Post

Next Post

Next

#2

Old

10-13-2024, 03:27 AM

p45cal

p45cal is offline

Reference Formula and cell reference

Windows 10 Reference Formula and cell reference

Reference Formula and cell reference

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal 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

	MSOfficeForums52907Benching.xlsx (12.0 KB, 5 views)
	MSOfficeForums52907BenchingForExcel2010.xlsx (12.8 KB, 2 views)

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

Reply With Quote

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:42 PM.