How to use an absolute reference when extending a formula sequence? [closed]

427 ●8 ●15 ●26

Say I want to have a sequence of formulae H6-A1, H7-A1, H8-A1...

How can I keep LibreOffice from increasing the row part of the second variable?

Because what I end up now when I drag the small square of the selection is H6-A1, H7-A2, H8-A3...

1 Answer

Sort by » oldest newest most voted

25744 ●7 ●53 ●139

You only need to put a $ to convert this part of the address in absolute, keeping their value when copying or drag.
=H6-A$1

Please take a look in the help or in documentation to learn more about absolute/relative addresses. https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Chapter 7 Formulas and Functions.

1 follower

Asked: 2014-01-11 23:51:39 +0100

Seen: 161 times

Last updated: Feb 19 '14