ExcelBanter - Help with a formula that keeps changing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with a formula that keeps changing (https://www.excelbanter.com/excel-discussion-misc-queries/268455-help-formula-keeps-changing.html)

thajtodad

Help with a formula that keeps changing

I have the follwimg formula
=D5+E12
If i want to make the formula continue as follows
=D5+E13
=D5+E14
=D5+E15
etc...
is there any way to do that besides typing in the formula multiple times?

tomgilb

Quote:

Originally Posted by thajtodad (Post 962503)

I have the follwimg formula
=D5+E12
If i want to make the formula continue as follows
=D5+E13
=D5+E14
=D5+E15
etc...
is there any way to do that besides typing in the formula multiple times?

If you put a $ in front of the column and/or row, it won't change, e.g. =$D$5+E12. You can copy this and paste into multiple cells below in the same column all at once and be done in one action.

All times are GMT +1. The time now is 09:12 PM.