Ask Your Question
0

Autofill cells with a formula Sequence [closed]

asked 2017-09-01 22:19:19 +0200

simontfs gravatar image

updated 2020-08-11 13:07:55 +0200

Alex Kemp gravatar image

I have a simple formula in Cell C2;

=SUM(A1+15000)-A1

I would like calc to auto fill the formula+1 for the selected cells (C2:C270)

like this

Cell C3;
=SUM(A1+15000)-A2
Cell C4;
=SUM(A1+15000)-A3
Cell C5;
=SUM(A1+15000)-A4

Is there any way to do this?

Thank you

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-08-11 13:08:04.011598

1 Answer

Sort by » oldest newest most voted
1

answered 2017-09-01 22:38:14 +0200

Lupp gravatar image

updated 2017-09-01 22:38:34 +0200

-1- Learn about absolute vs relative addressing.
=SUM(A$1+15000)-A2 'Sheet' > 'Fill Cells' > 'Down' (Ctrl+D) or drag fill handle with the mouse.

-2- For what reason that contrived formula? Use =A$1-15000-A2 or similar.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2017-09-01 22:19:19 +0200

Seen: 2,534 times

Last updated: Sep 01 '17