Forum Discussion
Row dependent function
HansVogelaar What goes inside the brackets? Does this formula need to be inserted into the relevant cell for each row? Not yet tried it out.
Nothing goes inside the brackets. ROW() returns the row number of the cell with the formula, and COLUMN() the column number of the cell with the formula.
Select the range into which you want the formulas, enter or copy/paste the formula from my previous reply and confirm it with Ctrl+Enter to enter it in all cells of the selection.
HansVogelaar Still require some more assistance before trying it out.
1. How / where do you select the range for this formula? I suppose that could be the start cell and the end cell of the column for this formula.
2. You say copy / paste the formula. But into which cell, or whereabouts on the spreadsheet?
Let's say that you want to apply the formula to G7:G100.
Select this range G7:G100.
Click in the formula bar.
If there is already a formula, delete it.
Type the formula from my reply manually, or copy it from that reply and paste it into the formula bar.
Press Ctrl+Enter.
HansVogelaar Progress of sorts. Instead of subtracting E values from G values, the resulting G values have the E values added to them. For example, G7=G6+E7, and not G7=G6-E7. Going down the G column results in increasing G values, whereas G needs to decrease in value. Over to you again.