For this week's exercise, have a look at the little bit of a spreadsheet shown below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 0 | 1 | 2 | 3 |
| 2 | 1 | X | ||
| 3 | 2 | |||
| 4 | 3 |
Your aim is to fill cells B2 to D4 with a formula which adds together the number of the row (in column A) and the number of the column (in row 1). The cell marked "X", for instance, should have a 2 in it.
The catch is that I'd like you to write the formula once, in cell B2, and then fill the remaining cells by copying and pasting that cell. No alteration of the result is allowed.
=(ROW(B2)-1)+(COLUMN(B2)-1)
ReplyDeletePut this formula in B2 and then drag to the other cells