I am trying to drag down formulas while advancing a column and a row each time I drag down.

I want to drag down the formula in N2 in such a way that the formula in N3 becomes


How can this be done?

1 Answer 1


I have forgotten what the requirement was (Sheets example is no longer publicly viewable) but assuming N2 is to calculate 1-(D2/B2) (N4: 1-(F4/D4) etc up to N11 at most) then perhaps:


in N2 and copied down to suit.

In N3 the effect would be of:

  • That does not seem to work but the general idea seems worth exploring (I did not know how to convert numbers to letters in sheets).
    – tiredoak
    Nov 28, 2016 at 9:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.