MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.