Google Sheets – How to Automatically Increase Exponent in Columns

google sheets

I have asked a similar question before
How to automatically increase the exponent in Google Spreadsheet?

But the new question is:

In a Google Spreadsheet, I put in the following numbers in a ROW, each number is an entry in the ROW.

100 100*1.01 100*1.01^2 100*1.01^3

The highest exponent of 1.01 is 3 for now. But I would like to keep filling this ROW until the exponent of 1.01 is 30. I can only do it by filling each entry in the ROW manually. How can I do this easier?

I tried 

=100*power(1.01, COLUMN(1:1))

But this does not work.

Best Answer

You can use

=100*power(1.01, COLUMN(A:A))

(That is, replace 1 by A). Actually, 

=100*power(1.01, COLUMN(A:A)-1)

would be better, as it allows you to apply the formula to all cells, including the very first one.

Also, the answer I gave to your other question works equally well here:

Put 100 in a cell (for example, B4), then enter in the cell to the right =1.01*B4, and extend the formula to the right.

Related Topic