Need big time help quick
Posted by jonathan on October 23, 2001 4:41 PM
I have to create a table along the lines of a multiplications table where it should be numbered from 1-10. Each cell in the table should contain the following value:
row raised to the power column. For example, the cell in row 2 of the table, column 3, should contain the value 2 raised to the power 3, which is equal to 8. I have to create a single formula using mixed references (relative and absolute) for the first cell (row 1 column 1), and copy this formula into all the other cells to get the entire table filled in.
Posted by Tom Urtis on October 23, 2001 5:01 PM
Is this what you are looking for?
Enter this formula in A1 and drag to right, and downwards, as you need.
=(ROW()^COLUMN())
Tom Urtis
Posted by Tom Urtis on October 23, 2001 5:19 PM
And one more thing...
In case you need to start your table in, say, cell H11, you can enter a modified formula and copy as needed, e.g. =(ROW()-10)^(COLUMN()-7).
I guess I'm not understanding where the relative and absolute references are needed in your case as you say you need, so if I'm missing something let me know.
Tom U.
