Mathieu Gouin
Mathieu Gouin

Reputation: 67

How to do a simple formula to do constant addition from cell above?

Basically I got a column of number that gets a constant number added to it, like +2 for every cell.

For example:

1
3
5
7

How do I do that in Sheet? I couldn't find a way to use the SUM formula, as I needed to reference the cell above and add +2 to it.

Upvotes: 0

Views: 66

Answers (1)

JPV
JPV

Reputation: 27262

Assuming you want 10 numbers, you could try

=sequence(10, 1, 1, 2)

Upvotes: 2

Related Questions