S
sbigelow
I started a formula that I thought was fairly simple. However, I can
seem to make it work.
Basically, I have a spreadsheet that gives me the rate of return on m
investment. Each day I enter the value of my investment in the cel
below the previous days value. So the formula would look like this:
(C226-C35)/C35
The problem is I have to change the row reference (C226) to the cel
containing the new value (say C227) each day (I dont like doing that).
Is there a way to have my formula automatically update to the newl
added value each day
seem to make it work.
Basically, I have a spreadsheet that gives me the rate of return on m
investment. Each day I enter the value of my investment in the cel
below the previous days value. So the formula would look like this:
(C226-C35)/C35
The problem is I have to change the row reference (C226) to the cel
containing the new value (say C227) each day (I dont like doing that).
Is there a way to have my formula automatically update to the newl
added value each day