G
Guest
I need to make a spreadsheet with formulas linking 2 pages together. The
formula is a IF formula and, going down the column, is in increments of 4
cells. ie: B4, B8, B12, etc. When I drag to fill the column with the formula
it automatically goes B5, B9, B13, B6, B10, etc. Hoy do I fix this so it is
one continuous stream of formulas incremented by 4 cells without writing in
each one. (long list!!)
formula is a IF formula and, going down the column, is in increments of 4
cells. ie: B4, B8, B12, etc. When I drag to fill the column with the formula
it automatically goes B5, B9, B13, B6, B10, etc. Hoy do I fix this so it is
one continuous stream of formulas incremented by 4 cells without writing in
each one. (long list!!)