G
G
GrogWORLD2022-01-15 20:27:18
Google Sheets
GrogWORLD, 2022-01-15 20:27:18

How to insert a function into a formula?

Everyone understands that in order to substitute the value of cell A1 into cell A2, it is enough to write a simple formula in cell A2: =А1.

How to change this simplest formula and “attach” the ROW function to it? It is very necessary that the line number is determined automatically. Or maybe there is another way?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2022-01-16
@GrogWORLD

Possibly
=ROW(A2)
Or something like
=INDIRECT("A" & ROW())

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question