Ask Your Question

Formatting cells in a series in Google Docs/Excel [closed]

asked 2017-05-23 08:42:33 +0200

Grimmjaxx gravatar image

updated 2020-09-24 15:56:49 +0200

Alex Kemp gravatar image

I don't know how to phrase this so here is what I'm trying to do: I have a series of cells that I need to increase by 50 every two cells. So here is my data: Cell 1: 0, Cell 2: 50 (+50), Cell 3: 100 (+50), Cell 4: 200 (+100), Cell 5: 300 (+100), Cell 6: 450 (+150), Cell 7: 600 (+150), etc. So is there a way to format the cell allowing the sequential increase to be every two cells instead of after every one? Sorry if this is confusing or not phrased well I wasn't very sure on how to explain this. Also to anyone who takes a look at this question, thanks for your time.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-05 00:11:23.153937

1 Answer

Sort by » oldest newest most voted

answered 2017-05-23 10:28:51 +0200

updated 2017-05-23 12:42:46 +0200

If A1 is 0, then put this to A2: =A1+50*TRUNC(ROW()/2) and drag-copy down to A3... as required.

Another (non-recursive) formula for this series is: =50*TRUNC(ROW()^2/4) (where ROW() defines the Nth series member). You might calculate your 35th number as =50*TRUNC(35^2/4) without need to get all previous members.

edit flag offensive delete link more


Thank you so much! I really appreciate it I had no idea what so ever on how to do this so you definitely made my day!

Grimmjaxx gravatar imageGrimmjaxx ( 2017-06-04 02:14:22 +0200 )edit

Question Tools

1 follower


Asked: 2017-05-23 08:42:33 +0200

Seen: 57 times

Last updated: May 23 '17