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
=1-(E3/C3)
How can this be done?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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
=1-(E3/C3)
How can this be done?
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:
=1-indirect(char(column()+52+row())&row())/indirect(char(column()+50+row())&row())
in N2 and copied down to suit.
In N3 the effect would be of:
=1-(E3/C3)