73.1k views
5 votes
What function returns a reference to a cell (or cell range) that is a specified number of row and columns from a base cell?

User Spong
by
6.7k points

1 Answer

6 votes

Answer:

The offset function

Explanation:

In Microsoft Excel, the offset function or formula returns reference to a particular cell.

The syntax is:

= OFFSET(reference, rows, cols)

Where:

reference = the base cell

rows and cols are the direction to move

For instance:

OFFSET(A1, 3, 1) will return cell B4

Because:

3 will shift down the reference from A1 to A4

1 will shift right the reference from A4 to B4

User Raedwald
by
6.6k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.