Can I reference a cell using a formula?

[Zalid]

Is there a way to make a formula reference a cell at set points.
I am trying to use a formula like =+H2+(C1+4). Where the C1+4 becomes C5. Subsequent H cells would then be C5+4=C9 etc

[schiavinatto]

Here’s a suggestion…

Zalid_ask_en.ods (11.4 KB)

[Zalid]

Excellent. Thanks for that

[LeroyG]

=H1+INDIRECT("C"&ROW()*4-7)

[Zalid]

Thanks for that