Search code examples
google-sheetsgoogle-sheets-formula

trying to add a formual to the "range" that adjusts which cell will be referenced rather than the value

I tried making a formula that adjusts which cell will be referenced rather than applying the formula to value of the cell im trying to reference

=Q2+11

but it just adds 11 to the value of Q2 instead of changing the reference cell to Q2 to Q13

i tried varius combinations of () like

=Q(2+11)

but it always applied my formula to the referenced cells rather than change the referenced cell to what i wanted.

Solution

  • A simpler alternative to the previous answer:

    =offset(Q2,11,0)