Google Sheets – How to Automatically Increase the Exponent

google sheets

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

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 column until the exponent of 1.01 is 30. I can only do it by filling each entry in the column manually. How can I do this easier?

Best Answer

Introduce the POWER function and use the ROW function to increment the exponent. Your second line would be,

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

Fill down and the ROW(1:1) will increment as 1, 2, 3, 4, 5, etc..

Related Topic