In a table I want a column in which each cell value depends on the value in the previous cell in the same column. For example, each entry to be double (or half, or the square of, etc) the value in the previous cell.

And I want this process to stop after a specified number of cells have been filled.

How can I do this, please?

Thanks,

Robert