I have a defined table of several rows and columns containing data and formulae. Some of the columns' cells' formulae are:
Where 'Weight' is the name of a column heading.
I want to change
=[@[Weight]]*1000 into something like
I've read converting to range does the trick (in the tools section of the Design tab menu). I've tried this however, it changes my formula to the following:
So, is there a way to change
=C3*1000 for all cells of this format?
'Sheet3'!$C3*1000, as the cell I'm editing is already in Sheet 3, so there shouldn't be a reason to reference Sheet 3)
Any help/advice is appreciated. Thanks in advance.