Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=OFFSET(A4,-1,5)

When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4 instead.

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=OFFSET(A4,-1,5)
=F3

When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4 instead.

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3

When this formula is filled down or copied, the A4 reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $A$4$F$3 instead.

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3

When this formula is filled down or copied, the reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as $F$3=$F$3 instead.

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3

Or perhaps you want this in cell A4:

=OFFSET(A4,-1,5)

When this formula is filled down or copied, the reference will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as =$F$3 instead.

To do what you are asking, INDIRECT is required: https://ask.libreoffice.org/en/question/64680/address-result-isnt-accepted-as-parameter/.

However, normally standard cell references are best, as answered here and here. That is, simply use:

=F3

Or perhaps you want this in cell A4:

=OFFSET(A4,-1,5)

When this formula is either of these formulas are filled down or copied, the reference references will automatically be changed for the new location.

Note: To prevent it from adjusting, write it as =$F$3 instead.