like making a rule or something.
I am trying to autofill a function, the first cell is (B14-B2)/B2, the second is (B26-B14)/B14, the third is (B38-B26)/B26, so I wanna to increase number by 12, however, the excel didn't get it and try to fill in (B17-B5)/B5;(B29-B17)/B17;(B41-B29)/B29; how can I let excel autofill function in the way I want it to?
Excel – how to customize autofill in excel2010
microsoft excel
Best Answer
If you want your ratios in
C2
,C3
,C4
, ..., for example, enterinto
C2
and autofill down toC3
,C4
, ....ROW()
returns the row number of the cell it is in, so we getOFFSET($B$2, number, 0)
refers to the cellnumber
rows belowB2
(and 0 columns to the right).